public void DataInforme_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = DataInforme.SelectedRow; try { LabNumeroOrden.Text = row.Cells[2].Text; string constr = ConfigurationManager.ConnectionStrings["CadenaConexion"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand CmdObtenerTopOrdenes = new SqlCommand("ObtenerTopOrdenes")) { CmdObtenerTopOrdenes.Connection = con; CmdObtenerTopOrdenes.CommandType = CommandType.StoredProcedure; CmdObtenerTopOrdenes.Parameters.AddWithValue("@IdOrden", row.Cells[2].Text); using (SqlDataAdapter daObtenerTopOrdenes = new SqlDataAdapter(CmdObtenerTopOrdenes)) { DataTable dtObtenerTopOrdenes = new DataTable(); daObtenerTopOrdenes.Fill(dtObtenerTopOrdenes); RepterUltimosComentarios.DataSource = dtObtenerTopOrdenes; RepterUltimosComentarios.DataBind(); } } } ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModalAgainShow", "$('#ModActualizacion').modal();", true); } catch (Exception ex) { // throw ex; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "showContent('error','" + ex + "');", true); } }
public void ObtenerTopOrdenes(int IdOrden) { string constr = ConfigurationManager.ConnectionStrings["CadenaConexion"].ConnectionString; if (IdOrden != null) { using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand CmdObtenerTopOrdenes = new SqlCommand("ObtenerTopOrdenes")) { CmdObtenerTopOrdenes.Connection = con; CmdObtenerTopOrdenes.CommandType = CommandType.StoredProcedure; CmdObtenerTopOrdenes.Parameters.AddWithValue("@IdOrden", IdOrden); using (SqlDataAdapter daObtenerTopOrdenes = new SqlDataAdapter(CmdObtenerTopOrdenes)) { DataTable dtObtenerTopOrdenes = new DataTable(); daObtenerTopOrdenes.Fill(dtObtenerTopOrdenes); RepterUltimosComentarios.DataSource = dtObtenerTopOrdenes; RepterUltimosComentarios.DataBind(); } } } } }