>>public partial class crlRoles : System.Web.UI.UserControl >>{ >> private DataSet dsRoles = null; >> private DataAccess DataLayer = null; >> >> protected void Page_Load(object sender, EventArgs e) >> { >> if (!IsPostBack) >> { >> dsRoles = new DataSet(); >> DataLayer = new DataAccess(); >> DataLayer.ConnectionString = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString; >> >> _LoadList(); >> } >> } >> >> private void _LoadList() >> { >> >> dsRoles = DataLayer.ExecuteQuery("as_GetRole", CommandType.StoredProcedure); >> >> lstRoles.DataSource = dsRoles.Tables[0]; >> lstRoles.DataMember = "RoleName"; >> } >>} >>>>