protected void GridViewAdminHospitals_Sorting(object sender, GridViewSortEventArgs e) { DataTable datatable = (DataTable)ViewState["table"]; if (datatable != null) { DataView view = new DataView(datatable); if (Convert.ToString(ViewState["sort"]).Contains("ASC") || Convert.ToString(ViewState["sort"]) == "") { view.Sort = e.SortExpression + " " + "DESC"; ViewState["sort"] = view.Sort.ToString(); } else { view.Sort = e.SortExpression + " " + "ASC"; ViewState["sort"] = view.Sort.ToString(); } GridViewAdminHospitals.DataSource = view; GridViewAdminHospitals.DataBind(); } }
public void bindGrid() { try { SqlCommand listHospitals = new SqlCommand("spAdminListOfHospitals", connection); listHospitals.CommandType = CommandType.StoredProcedure; connection.Open(); SqlDataAdapter sda = new SqlDataAdapter(listHospitals); DataTable dt = new DataTable(); sda.Fill(dt); ViewState["VSTable"] = dt; GridViewAdminHospitals.DataSource = dt; GridViewAdminHospitals.DataBind(); } catch (Exception e) { throw e; } finally { connection.Close(); } }