各位大虾帮帮俺
DataSet ds = new DataSet();
//核心SQL语句,进行查询运算(决定了分页的效率)
SqlDataAdapter MyAdapter = new SqlDataAdapter("Select Top "+PageSize+" * from redheadedfile where id not in(select top "+PageSize*CurrentPage+" id from softwareAdd order by id asc) order by id asc",MyCon());
MyAdapter.Fill(ds, "softwareAdd");
rep_s.DataSourceID = ds.Tables["softwareAdd"].DefaultView;
rep_s.DataBind();
//显示Label控件LCurentPage和文本框控件gotoPage状态
LCurrentPage.Text = (CurrentPage + 1).ToString();
gotoPage.Text = (CurrentPage + 1).ToString();
//释放SqlDataAdapter
MyAdapter.Dispose();
DataSet ds = new DataSet();
//核心SQL语句,进行查询运算(决定了分页的效率)
SqlDataAdapter MyAdapter = new SqlDataAdapter("Select Top "+PageSize+" * from redheadedfile where id not in(select top "+PageSize*CurrentPage+" id from softwareAdd order by id asc) order by id asc",MyCon());
MyAdapter.Fill(ds, "softwareAdd");
rep_s.DataSourceID = ds.Tables["softwareAdd"].DefaultView;
rep_s.DataBind();
//显示Label控件LCurentPage和文本框控件gotoPage状态
LCurrentPage.Text = (CurrentPage + 1).ToString();
gotoPage.Text = (CurrentPage + 1).ToString();
//释放SqlDataAdapter
MyAdapter.Dispose();
=====??
这里肯定不对
錯誤
ds.Tables["softwareAdd"].DefaultView;
是一個datatable
rep_s.DataSource = ds.Tables[0].DefaultView;
急的我用DataSourceID