private void ECLlenarComboidReview()
{
EC_Class EcCOMBO = new EC_Class();
string Query = "select Id from ECtbl_veterinaria";
DataSet ECset = EcCOMBO.LLenaComboGrid(Query);
DataTable ECtable = ECset.Tables[0];
foreach (DataRow row in ECtable.Rows)
{
ECcmbID.Items.Add(row[0].ToString());
}
}
private void EliminarComboid()
{
EC_Class ECbase = new EC_Class();
string Query = "select id from ECtbl_veterinaria";
DataSet ECdateset = ECbase.LLenaComboGrid(Query);
DataTable ECtable = ECdateset.Tables[0];
foreach (DataRow row in ECtable.Rows)
{
EC_comboxID.Items.Add(row[0].ToString());
}
}
private void ECcmbID_SelectedIndexChanged(object sender, EventArgs e)
{
EC_Class DatebaseEC = new EC_Class();
string Query2 = "select * from ECtbl_veterinaria where id = " + ECcmbID.Text;
DataSet ECdataset = DatebaseEC.LLenaComboGrid(Query2);
DataTable ECdatatable = ECdataset.Tables[0];
for (int f = 1; f < ECdataset.Tables.Count; f++)
{
ECdatatable = ECdataset.Tables[f];
}
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = ECdatatable;
}
private void EC_btn_Click(object sender, EventArgs e)
{
EC_Class DatebaseEC = new EC_Class();
string Query = " Select *from ECtbl_veterinaria";
DataSet ECdataset = DatebaseEC.LLenaComboGrid(Query);
DataTable ECdatatable = ECdataset.Tables[0];
for (int f = 1; f < ECdataset.Tables.Count; f++)
{
ECdatatable = ECdataset.Tables[f];
}
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = ECdatatable;
}
private void ECmontarDATOS(string id)
{
EC_Class datebaseEC = new EC_Class();
string Query = "select* from ECtbl_veterinaria where id=" + comboxID_EC.Text;
DataSet DataSetEC = datebaseEC.LLenaComboGrid(Query);
DataTable datatableEC = DataSetEC.Tables[0];
foreach (DataRow row in datatableEC.Rows)
{
comboxTipo_EC.Text = row[1].ToString();
EC_txtNombremascota.Text = row[2].ToString();
EC_txtNombreDueño.Text = row[3].ToString();
EC_txtApellido.Text = row[4].ToString();
EC_txtRut.Text = row[5].ToString();
EC_txtingreso.Text = row[6].ToString();
EC_txtSalida.Text = row[7].ToString();
EC_txtEstadia.Text = row[8].ToString();
EC_txtPeso.Text = row[9].ToString();
EC_txtTamaño.Text = row[10].ToString();
}
}