Populating Dropdown list
-
I have a dropdown list called ddlstat and I want to populate it with values from a database table called status. The value I want to get from Status table is Status name. here is the code for ddlstat: Private Sub ddlStat_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlStat.SelectedIndexChanged End Sub Does anyone have the code to use to populate a ddl. Thanks macca
-
I have a dropdown list called ddlstat and I want to populate it with values from a database table called status. The value I want to get from Status table is Status name. here is the code for ddlstat: Private Sub ddlStat_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlStat.SelectedIndexChanged End Sub Does anyone have the code to use to populate a ddl. Thanks macca
im not sure if this is what your looking for but...
Private Sub ddlStat_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlStat.SelectedIndexChanged ddlstat.items.clear dim i as integer For i = 0 To (DataSet11.Tables("status").Rows.Count - 1) ddlstat.items.add(DataSet11.Tables("employee").Rows(i).Item("Status_Name")) 'status_name = column name in table next end sub