Visual Basic

<br />
<br />
Private Sub ddlStat_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlStat.SelectedIndexChanged<br />
<br />
ddlstat.items.clear<br />
dim i as integer<br />
<br />
For i = 0 To (DataSet11.Tables("status").Rows.Count - 1)<br />
ddlstat.items.add(DataSet11.Tables("employee").Rows(i).Item("Status_Name")) 'status_name = column name in table<br />
next<br />
<br />
end sub<br />

<br />
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged<br />
<br />
Label1.Text = "You Clicked On row " & (ComboBox1.SelectedIndex + 1).ToString<br />
<br />
    End Sub