private void BtnMostrarSQL_Click(object sender, EventArgs e) { try { using (var context = new ChoppinEntities()) { var connection = context.Database.Connection; connection.Open(); using (var cmd = connection.CreateCommand()) { var dt = new DataTable(); cmd.CommandType = CommandType.Text; cmd.CommandText = TxtSql.Text; using (var reader = cmd.ExecuteReader()) { dt.Load(reader); GridTabla.DataSource = dt; GridTabla.Refresh(); } } connection.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void BtnAgregar_Click(object sender, EventArgs e) { using (var context = new ChoppinEntities()) { var contextTabla = context.GetType().GetProperty(TablaNombre); var data = contextTabla.GetValue(context); var typeData = data.GetType().GenericTypeArguments[0]; var registro = Activator.CreateInstance(GridTabla.Rows[0].DataBoundItem.GetType()); var registros = ((IList <object>)GridTabla.DataSource); registros.Add(registro); GridTabla.DataSource = registros; GridTabla.Refresh(); } }
private void RefrescarTabla() { try { using (var context = new ChoppinEntities()) { var contextTabla = context.GetType().GetProperty(TablaNombre); var data = contextTabla.GetValue(context); var datos = ((IEnumerable <object>)data).ToList(); var registros = datos; GridTabla.AutoGenerateColumns = true; GridTabla.DataSource = registros; GridTabla.Refresh(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }