protected void Grid_Diagnostico_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
//GuardarDiagnosticos();
Grid_Diagnostico.PageIndex = e.NewPageIndex;
Grid_Diagnostico.DataBind();
LlenarGridDiagnostico();
}
public void LlenarGridDiagnostico()
{
string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection cnn;
cnn = new SqlConnection(conexion);
cnn.Open();
SqlCommand comando = new SqlCommand("SP_Catalogo_Diagnostico", cnn);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@Opcion", "LISTADO");
if (!(txtBuscar_Diagnostico.Text == ""))
{
string s = txtBuscar_Diagnostico.Text;
string[] palabras = s.Split(' ');
int i = 0;
foreach (string palabra in palabras)
{
if (i <= 4)
{
string NDescripcion = "@Descripcion_Diagnostico" + i;
comando.Parameters.AddWithValue(NDescripcion, palabra);
i++;
}
}
}
else
{
comando.Parameters.AddWithValue("@Descripcion_Diagnostico1", "");
}
/*
* 0 Id_Empresa
* 1 Nombre_Empresa
*/
SqlDataAdapter da = new SqlDataAdapter(comando);
DataTable ds = new DataTable();
da.Fill(ds);
Grid_Diagnostico.Visible = true;
Grid_Diagnostico.DataSource = ds;
Grid_Diagnostico.Columns[0].Visible = true;
Grid_Diagnostico.Columns[1].Visible = true;
Grid_Diagnostico.DataBind();
ds.Dispose();
da.Dispose();
txtBuscar_Diagnostico.Focus();
}
public void LlenarGridDiagnostico()
{
string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection cnn;
cnn = new SqlConnection(conexion);
cnn.Open();
SqlCommand comando = new SqlCommand("SP_Catalogo_Diagnostico", cnn);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@Opcion", "LISTADO");
if (txtBuscar_Sexo.Text == "")
{
comando.Parameters.AddWithValue("@Descripcion_Diagnostico", "");
}
else
{
comando.Parameters.AddWithValue("@Descripcion_Diagnostico", txtBuscar_Sexo.Text);
}
/*
* 0 Id_Empresa
* 1 Nombre_Empresa
*/
SqlDataAdapter da = new SqlDataAdapter(comando);
DataTable ds = new DataTable();
da.Fill(ds);
Grid_Diagnostico.Visible = true;
Grid_Diagnostico.DataSource = ds;
Grid_Diagnostico.Columns[0].Visible = true;
Grid_Diagnostico.Columns[1].Visible = true;
Grid_Diagnostico.DataBind();
ds.Dispose();
da.Dispose();
}
