protected void BuscarButton_Click(object sender, EventArgs e)
{
Vacunas vacu = new Vacunas();
string filtro = "";
if (string.IsNullOrWhiteSpace(FiltroTextBox.Text))
{
filtro = "1=1";
}
else
{
if (FiltroDropDownList.SelectedIndex == 0)
{
filtro = "VacunaId = " + FiltroTextBox.Text;
}
else
{
filtro = FiltroDropDownList.SelectedValue + " like '%" + FiltroTextBox.Text + "%'";
}
}
DataTable dt = new DataTable();
dt = vacu.Listado("VacunaId,Descripcion ", filtro, "");
ConsultaGridView.DataSource = dt;
ConsultaGridView.DataBind();
}
public void LlenarComboboxVacuna()
{
DataTable data = new DataTable();
data = vacuna.Listado("VacunaId,NombresVacunas", "0=0", "ORDER BY VacunaId");
VacunacomboBox.DataSource = data;
VacunacomboBox.ValueMember = "VacunaId";
VacunacomboBox.DisplayMember = "NombresVacunas";
}
private void VacunaLlenarDropDownList()
{
Vacunas vacu = new Vacunas();
VacunaDropDownList.DataSource = vacu.Listado(" * ", " 1=1 ", " ");
VacunaDropDownList.DataTextField = "Descripcion";
VacunaDropDownList.DataValueField = "VacunaId";
VacunaDropDownList.DataBind();
VacunaDropDownList.Items.Insert(0, "Selecionar");
}
private void BuscarButton_Click(object sender, EventArgs e)
{
Vacunas vacuna = new Vacunas();
string filtro = "1=1";
if (FiltrotextBox.Text.Length > 0)
{
filtro = CamposcomboBox.Text + " like '%" + FiltrotextBox.Text + "%'";
}
ConsultadataGridView.DataSource = vacuna.Listado("VacunaId,NombresVacunas", filtro, "");
ConteotextBox.Text = ConsultadataGridView.RowCount.ToString();
}
