MS Access Error

[hisheeraz]

Hello Friends
im having trouble loading data into database into the form
here is my code

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim Oconn As OleDb.OleDbConnection = New  OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Application.StartupPath & "\dbn.mdb")
        Oconn.Open()
        sql = "select aname from tbln"
        da = New OleDb.OleDbDataAdapter(sql, Oconn)
        ds = New DataSet
        da.Fill(ds, "tbln")
        [B]txtname.Text = ds("aname")[/B]
End Sub

im having error at the bold code...
the error is

Error 1 Class 'System.Data.DataSet' cannot be indexed because it has no default property. C:\Documents and Settings\§ RentedLips §\Desktop\VisualBasic2008\Db\Db\Form1.vb 21 24 Db

Please help me!
Thanks
hisheeraz

 

[Tom]

Column aname could return multiple rows from the table. You must specifiy the dataset, table name, row within the table and the column to show which field value you want to display in your textbox.

For example

txtname.Text = ds.Tables("tbln").Rows(RowIndexHere).Item("aname").toString

 

[hisheeraz]

Thank You Tom, Problem Sorted. Cheers!

 

[cjard]

Column aname could return multiple rows from the table. You must specifiy the dataset, table name, row within the table and the column to show which field value you want to display in your textbox.

For example

txtname.Text = ds.Tables("tbln").Rows(RowIndexHere).Item("aname").toString

the actual error was caused by a generic dataset having no default property. It is thus an error to say:

Dim myDs as New DataSet
myDs("someTable") <-- there is no property of a dataset that takes a string and returns a DataTable

Saying myDs.Tables("someTable") would not give the error (although, right now the dataset doesnt contain a table of taht name.. thats a different error)