public void PopulateGridView()
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(ConnectionString))
//SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["PharmacyConnectionString"].ConnectionString);
{
conn.Open();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM BrandList", conn);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
ViewState["Paging"] = dt;
//BrandGridView.DataSource = null;
BrandGridView.DataSource = dt;
BrandGridView.DataBind();
ViewState["dirState"] = dt;
ViewState["sortdr"] = "Asc";
}
else
{
BrandGridView.DataSource = dt;
BrandGridView.DataBind();
ErrorLbl.Text = "No records found...!!!";
successLbl.Text = "";
}
conn.Close();
}
}
protected void BrandGridView_Sorting(object sender, GridViewSortEventArgs e)
{
DataTable dt = (DataTable)ViewState["dirState"];
if (dt.Rows.Count > 0)
{
if (Convert.ToString(ViewState["sortdr"]) == "Asc")
{
dt.DefaultView.Sort = e.SortExpression;
ViewState["sortdr"] = "Desc";
}
else
{
dt.DefaultView.Sort = e.SortExpression;
ViewState["sortdr"] = "Asc";
}
BrandGridView.DataSource = dt;
BrandGridView.DataBind();
}
}
protected void BrandGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
BrandGridView.PageIndex = e.NewPageIndex;
BrandGridView.DataSource = ViewState["Paging"];
BrandGridView.DataBind();
}