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