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