I'm new to ASP so I need help to do the following:
I need to populate a Dropdownlist with data from an Access database table. I can bind the control to a DataSource in design mode but I want to fill the dropdownlist with data using code so that I can add on the first row a blank row or some kind of message like "Choose your Color...". So far I've writen the code below, then I got stucked...
Can you please help me do this?
Dim strSql As String = ""
strSql = "SELECT [Descricao] FROM [Leis] ORDER BY [Descricao]"
Dim Conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Programação\AEDemo\db\manpower.mdb")
Dim Cmd As New OleDbCommand(strSql, Conn)