RE:llenar un DropDownList con datos de una consult
Pues es muy sencillo. Creas una funcion que te retorne un Dataset y luego en el Page Load la llamas si no hay un postback. Por ejemplo
Function GetCategorias() As DataSet
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=D:\Itaca\ItacaD"& _
"ata.mdb"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)
Dim queryString As String = "SELECT [CATEGORIA].[CO_CATEGORIA], [CATEGORIA].[NB_CATEGORIA] FROM [CATEGORIA]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet
dataAdapter.Fill(dataSet)
Return dataSet
End Function
Sub Page_Load(Sender As Object, E As EventArgs)
If Not Page.IsPostBack Then
DropDownList1.DataTextField = "nb_categoria"
DropDownList1.DataValueField ="co_categoria"
DropDownList1.DataSource = GetCategorias()
DropDownList1.DataBind()
End If
End Sub