dropdown query

[Mahesh Varia]

hi eveyone!!.
i am a fresher to asp.net,i want to fill dropdownlist from database.i have used follo. code but shows "System.data.datarowview:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim ConnectionString As String
ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source= D:\datalearn.mdb"

Dim myAdapter As New OleDbDataAdapter("SELECT name FROM tbname", ConnectionString)
Dim myDataset As New DataSet

myAdapter.Fill(myDataset, "tbname")

ddname.DataSource = myDataset.Tables(0).DefaultView
ddname.DataBind()

End Sub

[AricC]

hi eveyone!!.
i am a fresher to asp.net,i want to fill dropdownlist from database.i have used follo. code but shows "System.data.datarowview:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim ConnectionString As String
ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;Data Source= D:\datalearn.mdb"

Dim myAdapter As New OleDbDataAdapter("SELECT name FROM tbname", ConnectionString)
Dim myDataset As New DataSet

myAdapter.Fill(myDataset, "tbname")

ddname.DataSource = myDataset.Tables(0).DefaultView
ddname.DataBind()

End Sub

Haven't done this for awhile but it doesn't look like your opening the database connection.