like the web application bindings i need same senario in windows application also.
please see the below code for web application dropdown list.
Sub BindListbox(ByVal tsqlstring As String, ByVal DDlListbox As DropDownList, ByVal DMember As String, ByVal DTextField As String, ByVal DValuefield As String)
Dim dbConn As OleDbConnection
Dim selectCommandZones As OleDbCommand
Dim Dr As OleDbDataReader
Dim sqlString As String
sqlString = tsqlstring
dbConn = New OleDbConnection(ConnString
)
dbConn.Open()
selectCommandZones = New OleDbCommand(sqlString, dbConn)
Dr = selectCommandZones.Execute
Reader()
DDlListbox.DataSource = Dr
DDlListbox.DataMember = DMember
DDlListbox.DataTextField = DTextField
DDlListbox.DataValueField = DValuefield
DDlListbox.DataBind()
dbConn.Close()
End Sub
Start Free Trial
