private void CargarRoles() { Cls_Roles_BLL objBLL = new Cls_Roles_BLL(); Cls_Roles_DAL objDAL = new Cls_Roles_DAL(); gdvRoles.DataSource = null; gdvRoles.DataBind(); objBLL.Listar(ref objDAL); if (objDAL.sError == string.Empty) { gdvRoles.SelectedIndex = -1; if (txtBuscar.Value == string.Empty) { gdvRoles.DataSource = objDAL.dtTabla; } else { DataTable dt = objDAL.dtTabla; EnumerableRowCollection <DataRow> query = from dtRoles in dt.AsEnumerable() where dtRoles.Field <string>("Rol").ToLower().Replace(" ", "").Contains(txtBuscar.Value.ToLower().Replace(" ", "")) select dtRoles; DataView view = query.AsDataView(); gdvRoles.DataSource = view; } gdvRoles.DataBind(); if (gdvRoles.Rows.Count > 0) { gdvRoles.Visible = true; lblMensaje.Visible = false; lblMensaje.Text = ""; } else { gdvRoles.Visible = false; lblMensaje.Visible = true; lblMensaje.Text = "No hay datos que mostrar"; } } else { lblMensaje.Text = objDAL.sError; } }
public void CargarCombos() { Cls_Roles_BLL objBLL = new Cls_Roles_BLL(); Cls_Roles_DAL objDAL = new Cls_Roles_DAL(); objBLL.Listar(ref objDAL); if (objDAL.sError == string.Empty) { cmbRoles.DataSource = null; cmbRoles.DataSource = objDAL.dtTabla; cmbRoles.DataTextField = "Rol"; cmbRoles.DataValueField = "Id_Rol"; cmbRoles.DataBind(); cmbRoles.SelectedIndex = 0; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowPopup", "alert('Se presento un problema a la hora de cargar el combo de roles');", true); } }
public DataTable listarRol(ref string sMsj_error) { Cls_Roles_BLL Obj_Rol_BLL = new Cls_Roles_BLL(); return(Obj_Rol_BLL.Listar(ref sMsj_error)); }