Here's some code if it helps:
lstUsers is the dropdownlist.Code:Dim connStringRPP As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "data source=d:\test.mdb" Dim cnRPP As New OleDb.OleDbConnection(connStringRPP) Dim cmdTextRPP As String = "SELECT * FROM Bio ORDER BY fldLastName ASC" Dim cmdRPP As New OleDb.OleDbCommand(cmdTextRPP, cnRPP) Dim daRPP As New OleDb.OleDbDataAdapter(cmdRPP) Dim dsRPP As New DataSet() daRPP.FillSchema(dsRPP, SchemaType.Source, "Bio") daRPP.Fill(dsRPP, "Bio") lstUsers.DataSource = dsRPP lstUsers.DataBind()




Reply With Quote