private void Fillddl()
{
DataTable dtNames = new DataTable();
dtNames = GetNames();
if (dtNames != null)
{
ddlid.DataSource = dtNames ;
ddlid.DataTextField = "NAME";
ddlid.DataValueField = "ROLL_NO";
ddlid.DataBind();
}
ddlid.Items.Insert(0, "Select");
ddlid.Items[0].Value = "-1";
}
In GetNames()
Get datatable with two columns NAME and ROLL_NO
Using any of database query
IF it returns
NAME ROLL_NO
-----------------
Manoj 456456
Roshan 789456
Ur Drop down will contain
Select
Manoj
roshan
with value respective roll number