protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
bindDropDownList();
}
protected void bindDropDownList()
{
string constr = ConfigurationManager.ConnectionStrings["yourConnectionString"].ToString();
SqlConnection con =new SqlConnection (constr);
con.Open();
SqlCommand com=new SqlCommand ("select * from ROLEID",con);
SqlDataAdapter da=new SqlDataAdapter(com);
DataSet ds = new DataSet ();
da.Fill(ds);
DropDownList1.DataTextField = ds.Tables[0].Columns["ROLE"].ToString(); DropDownList1.DataValueField=ds.Tables[0].Columns["ID"].ToString();
DropDownList1.DataSource=ds.Tables[0];
DropDownList1.DataBind();
}
Remember that you should use stored procedure in place of direct query.