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