accessing the data from a wizard gen xsd dataset table

How do a do this in the vb side of my aspx form to add a new row in my table
when I create a xsd dataset. I've searched with no luck. See the the do it
by code after the do it by wizard.

Wizard Code

Imports System.Data
Imports dsRSS
Imports dsRSS.tblRSSStoriesDataTable


Partial Class Default2
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load

Dim ntbl As DataTable
Dim ndr As DataRow

*** ntbl = dsrss.tblRSSStoriesDataTable("tblrssstories)" ***

I get can not be used as an expression?

I created a web solution using hand coded data connections (WROX ASP NET1.0)
and I get the expeccted results

Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports System.Data
Imports System.Data.OleDb

Partial Class _Default
Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
Dim strconn As String
Dim strsql As String
Dim ds As New DataSet
Dim dbcon As OleDbConnection
Dim dba As OleDbDataAdapter

strconn = "Provider=Microsoft.JET.OLEDB.4.0; " & _
"Data Source=C:\Inetpub\wwwroot\ReadRSSFeeds\RSSFeeds.mdb"

strsql = "Select * " & _
"From tblRSSStories"

dbcon = New OleDbConnection(strconn)
dba = New OleDbDataAdapter(strsql, dbcon)

dba.Fill(ds, "rssStories")

dgview1.DataSource = ds.Tables("rssStories")
dgview1.DataBind()

Dim ntbl As DataTable
Dim ndr As DataRow

ntbl = ds.Tables("rssStories")
ndr = ntbl.NewRow() End Sub
End Class
.

Relevant Pages

  • add a new table/row from a xsd dataset created bt tableadapter wiz
    ... when I create a xsd dataset. ... Imports System.Data ... Dim ntbl As DataTable ... Dim dbcon As OleDbConnection ...
    (microsoft.public.vsnet.general)
  • Re: Shared functions vs Non-Shared Functions
    ... > dim context as HttpContext = HttpContext.Current ... Imports Microsoft.VisualBasic ... Public Shared sub sendEmail ... >> dim webMasterEmail As String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Importing text, etc. on remote .mdb file
    ... You can then use VBA string functions to get from there to the ... Is there an easy way to schedule the imports of the text files so I ... 'Modify strSQL and filenames as required ... Dim oJet 'DAO.DBEngine ...
    (microsoft.public.access.externaldata)
  • Re: .net remoting vs SQL Server
    ... The connection to the database will only exist as long as the method runs. ... Imports System.Runtime.Remoting ... Public Function ConnectionString() As String ... Dim oCmd As SqlCommand = New SqlCommand ...
    (microsoft.public.dotnet.framework.remoting)
  • RE: Logon Error
    ... > Imports CrystalDecisions.CrystalReports ... > function is emailPDFwhich calls ChangeLogOnInfo EmailPDF returns a Report ... > Dim szErrorMailSecondary As String 'This is where all the mail messages ...
    (microsoft.public.dotnet.framework.aspnet)
Loading