protected void GrvActasSorting(object sender, GridViewSortEventArgs e) { var dt = HttpContext.Current.Session["dtActas"] as DataTable; if (dt != null) { dt.DefaultView.Sort = e.SortExpression + " " + GetSortDirection(e.SortExpression); GrvActas.DataSource = HttpContext.Current.Session["dtActas"]; GrvActas.DataBind(); } }
protected void GrvActasPageIndexChanging(object sender, GridViewPageEventArgs e) { var dt = HttpContext.Current.Session["dtActas"] as DataTable; if (dt != null) { GrvActas.PageIndex = e.NewPageIndex; GrvActas.DataSource = dt; GrvActas.DataBind(); } }
// Method Cargues private void CargarActas() { DataTable tabla_sql = new DataTable(); String sqlConsulta = ""; try { //Consulta. sqlConsulta = " SELECT E.Id_Acta ,E.NumActa ,E.NomActa ,c.NomConvocatoria ,e.publicado " + " FROM evaluacionacta e JOIN convocatoria c ON id_convocatoria = codconvocatoria " + " ORDER BY NumActa "; //Asignar resultados a variable DataTable. tabla_sql = consultas.ObtenerDataTable(sqlConsulta, "text"); HttpContext.Current.Session["dtActas"] = tabla_sql; GrvActas.DataSource = tabla_sql; GrvActas.DataBind(); } catch { } }