【在线等答案,关于“未将对象引用设置到对象的实例。”】
protected void bindgrid()
{
SqlConnection sqlcon = new SqlConnection("Data Source=.;Initial Catalog=chapter;Integrated Security=True");
DataSet ds = new DataSet();
int total;
sqlcon.Open();
SqlDataAdapter sqld = new SqlDataAdapter("select * from ueserInfo", sqlcon);
sqld.Fill(ds, "userInfo");
total = ds.Tables["userInfo"].Rows.Count;
totalnumber.Text = "共" + ((total - total % dg.PageSize)/dg.PageSize + 1).ToString() + "页";
DataTable dtable = ds.Tables["userInfo"];
DataView dview = new DataView(dtable);
if(total==0)
{
pagenumber.Text += "没有可以显示的内容!";
return;
}
if (Session["mail"]!="")
{
dview.Sort = Session["mail"].ToString();
dg.DataSource = dview;
}
else
{
dg.DataSource = ds.Tables["userInfo"].DefaultView;
}
dg.DataBind();
sqlcon.Close();
sqlcon = null;
//labcontent.Text += "欢迎查看表!";
}
void gridsort(Object sender, DataGridSortCommandEventArgs e)
{
Session["mail"] = e.SortExpression;
bindgrid();
}
void changepage(Object sender,DataGridPageChangedEventArgs e)
{
dg.CurrentPageIndex = e.NewPageIndex;
pagenumber.Text = "第" + dg.CurrentPageIndex + 1 + "页";
bindgrid();
}