private void BindRole()
{
BALDropDownList DDL = new BALDropDownList();
DataTable dtDesignation = HRMWcfService1.BALDropDownList.DesignationList();
DrpRole.DataSource = dtDesignation;
DrpRole.DataTextField = "DesignationType";
DrpRole.DataValueField = "DesignationID";
DrpRole.DataBind();
DrpRole.Items.Insert(0, new ListItem("---Select Designation---"));
}
protected void DropDown_Binding()
{ //DropDown Binding on Roles
try
{
ConStr = ConfigurationManager.ConnectionStrings["GetConnection"].ConnectionString;
Conn = new SqlConnection(ConStr);
Conn.Open();
string query = "select * from RoleTable";
SqlDataAdapter adpt = new SqlDataAdapter(query, Conn);
DataTable dt = new DataTable();
adpt.Fill(dt);
DrpRole.DataSource = dt;
DrpRole.DataBind();
DrpRole.DataTextField = "Role_Desc";
DrpRole.DataValueField = "Role_ID";
DrpRole.DataBind();
}
catch (Exception)
{
throw;
}
}
