Hi,
see my comments on your code
public DataView binddata()
{
string ConnectionString = ConfigurationManager.ConnectionStrings["lawrece"].ConnectionString;
SqlConnection con = new SqlConnection(ConnectionString);
String StrQuery = "select * from TableName";
SqlDataAdapter adp = new SqlDataAdapter(StrQuery, con);
DataSet ds = new DataSet();
adp.Fill(ds);
DataView dv = new DataView();
if (ViewState["sortExpr"] != null)
{
dv = new DataView(ds.Tables[0]);
dv.Sort = (string)ViewState["sortExpr"];
}
else
{
dv = ds.Tables[0].DefaultView;
}
return dv;
}
Hope it helps