F
Franz
Hi,
If my ProjectTable contains a lot of rows, each time I call the following
code, will all the rows be fetched? Or only those 5 records for that page
are fetched only?
/* -- code start -- */
OdbcConnection connection = new OdbcConnection("DSN=Whatever");
connection.Open();
string query = "SELECT * FROM ProjectTable";
OdbcDataAdapter dataAdapter = new OdbcDataAdapter(query, connection);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
PagedDataSource pagedDataSrc = new PagedDataSource();
pagedDataSrc.DataSource = dataSet.Tables[0].DefaultView;
pagedDataSrc.AllowPaging = true;
pagedDataSrc.PageSize = 5;
setPageIndex();
MyRepeater.DataSource = pagedDataSrc;
MyRepeater.DataBind();
/* -- code end -- */
Thanks,
Franz
If my ProjectTable contains a lot of rows, each time I call the following
code, will all the rows be fetched? Or only those 5 records for that page
are fetched only?
/* -- code start -- */
OdbcConnection connection = new OdbcConnection("DSN=Whatever");
connection.Open();
string query = "SELECT * FROM ProjectTable";
OdbcDataAdapter dataAdapter = new OdbcDataAdapter(query, connection);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
PagedDataSource pagedDataSrc = new PagedDataSource();
pagedDataSrc.DataSource = dataSet.Tables[0].DefaultView;
pagedDataSrc.AllowPaging = true;
pagedDataSrc.PageSize = 5;
setPageIndex();
MyRepeater.DataSource = pagedDataSrc;
MyRepeater.DataBind();
/* -- code end -- */
Thanks,
Franz