dt是我要帮定的数据源,一datatable OleDbConnection MyConn = new OleDbConnection("Provider=SQLOLEDB; Data Source=192.0.0.199;Initial Catalog=datacenter;Persist Security Info=True;User ID=sa;Password=masterkey");
MyConn.Open();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();
DataSet myDataSet = new DataSet();
OleDbCommand MyCmd = new OleDbCommand("select * from dt", MyConn);
MyAdapter.SelectCommand = MyCmd;
myDataSet.Tables.Add(dt);
int startdata = datasize * (Int32.Parse(pagenum) - 1);
MyAdapter.Fill(myDataSet, startdata, datasize, "result");
MyConn.Close(); DataList3.DataSource = myDataSet.Tables["result"].DefaultView;
DataList3.DataBind();
MyConn.Open();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();
DataSet myDataSet = new DataSet();
OleDbCommand MyCmd = new OleDbCommand("select * from dt", MyConn);
MyAdapter.SelectCommand = MyCmd;
myDataSet.Tables.Add(dt);
int startdata = datasize * (Int32.Parse(pagenum) - 1);
MyAdapter.Fill(myDataSet, startdata, datasize, "result");
MyConn.Close(); DataList3.DataSource = myDataSet.Tables["result"].DefaultView;
DataList3.DataBind();
MyAdapter.Fill(myDataSet, startdata, datasize, "result");
有关的,是你从DataSet里取数据的才要做分页的操作2.你的数据是SQL Server就不要用OleDbConnection连接,都换成Sqlconnection
你的数据库中没dt这张表,请确认
》》
MyAdapter.Fill(myDataSet, startdata, datasize, "dt");
这个分页,我是不用OleDbConnection的。因为我所有数据都在dt这张表里,我每次取5个出来为啥说这个和分页没有关系呢?
你还没定义dt是什么呢
这之前 DataTable dt = new DataTable();
dt.TableName = "dt";
SqlCommand MyCmd = new SqlCommand();
OleDbCommand MyCmd = new OleDbCommand("select * from result", DBConnection);
myDataAdapter.SelectCommand = MyCmd;
DataSet myDataSet = new DataSet();
myDataSet.Tables.Add(dt);
int startdata = datasize * (Int32.Parse(pagenum) - 1);
myDataAdapter.Fill(myDataSet, startdata, datasize, "result");所有对象都在前面声明了,一样报错