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