62,046
社区成员
发帖
与我相关
我的任务
分享
SqlConnection conn = new SqlConnection(str);
conn.Open();
string sqlstr =string .Format( "select top 5 * from book_info where ID not in (select top {0} ID from book_info)",index*5);//每5条数据显示一页 查询5条数据不在已经显示的ID中的数据
SqlDataAdapter ada = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
ada.Fill(ds, "mytable");
GridView2.DataSource = ds.Tables["mytable"];
GridView2.DataBind();
DataTable dt = new DataTable();
DataView dv = new DataView();
dv = dt.DefaultView;