public static void FillGridView(DataGridView gv, DataTable myDataTable, bool autoGenColumns) { QUERY Tabla = new QUERY(); gv.AutoGenerateColumns = autoGenColumns; gv.DataSource = myDataTable; }
public static void FillGridView(DataGridView gv, string TableName, bool autoGenColumns) { QUERY Tabla = new QUERY(); gv.AutoGenerateColumns = autoGenColumns; gv.DataSource = Tabla.GetRecords(TableName); }
/// <summary> /// Permite validar los permisos en controles Windows forms /// </summary> /// <param name="objetoContenedor"></param> public static void habilitarPermisos(Control objetoContenedor, int perfil) { try { foreach (Control ctrl in objetoContenedor.Controls) { if (ctrl.Tag != null && ctrl.Tag.ToString().Length > 0) { QUERY Query = new QUERY(); string sql = "SELECT idRol,idComando FROM permiso p WHERE p.idRol = " + perfil + " and p.idComando =" + ctrl.Tag + " order by p.idComando;"; DataTable DTP = Query.Consultar(sql); if (DTP.Rows.Count > 0) { ctrl.Visible = true; } else { ctrl.Visible = false; } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public static void FillCombobox(DataGridViewComboBoxCell cbo, string TableName, string ValueMember, string DisplayMember) { QUERY Tabla = new QUERY(); cbo.DataSource = Tabla.GetRecords(TableName); cbo.DisplayMember = DisplayMember; cbo.ValueMember = ValueMember; }