problem populating drop down

d2005

Active member
Joined
Aug 31, 2005
Messages
37
Location
ireland
Programming Experience
Beginner
trying to populate a drop down, any one see a problem

VB.NET:
 Private Sub fill_area() 
Dim sqlfillarea As New SqlCommand("SELECT * from tb_area", oSQLConn)

'daArea.Fill()

oSQLConn.Open()

Me.ddlArea.DataSource = daArea

Me.ddlArea.DataValueField = "area_name"

Me.ddlArea.DataTextField = "area_name"

Me.ddlArea.DataBind()

oSQLConn.Close()

End Sub
 
Back
Top