private void FillRoles(DropDownList ddl) { try { ddl.Items.Clear(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) { using (SqlDataReader dr = WSCSecurity.SecurityRoleGetAll(conn)) { System.Web.UI.WebControls.ListItem item = new ListItem("All", "0"); ddl.Items.Add(item); while (dr.Read()) { int roleID = dr.GetInt16(dr.GetOrdinal("sro_role_id")); item = new ListItem(dr.GetString(dr.GetOrdinal("sro_role_name")), roleID.ToString()); ddl.Items.Add(item); } } } ddl.SelectedIndex = 0; } catch (Exception ex) { Common.CException wex = new Common.CException("Security.FillRoles", ex); throw (wex); } }
private void FillRoles(ListBox lst) { try { lst.Items.Clear(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["BeetConn"].ToString())) { using (SqlDataReader dr = WSCSecurity.SecurityRoleGetAll(conn)) { while (dr.Read()) { int roleID = dr.GetInt16(dr.GetOrdinal("sro_role_id")); ListItem item = new ListItem(dr.GetString(dr.GetOrdinal("sro_role_name")), roleID.ToString()); lst.Items.Add(item); } } } } catch (Exception ex) { Common.CException wex = new Common.CException("Security.FillRoles", ex); throw (wex); } }