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; } }