Hi there,
I'm really struggling with this tonight (this being exactly what it says on the tin, (or the subject!)).
Code I'm working with right now is:
If Not Page.IsPostBack Then
Dim Category As String
Dim CategoryReader As OdbcDataReader = Database.Read("SELECT * FROM tblBlogCategory")
While CategoryReader.Read()
Category = CategoryReader("Category").ToString()
End While
DropDownList1.DataSource = Category
DropDownList1.DataBind()
End If
I've also tried things like
DropDownList1.DataSource = Database.Read("SELECT * FROM tblBlogCategory") but it just stubbornly refuses to populate the list (i.e. the page
always loads with a blank drop down list).
An idea I'm playing around with is putting the values of the Category table into an array, but it seems to have a problem with that as well. Go to the complete details ...