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