dogekid
03-21-2005, 03:22 PM
hello.
so i'm trying to add basic paging to my data grid, under "normal circumstances" w/ a direct SQL query, things would be easy, however i'm using oracle and taking the following steps:
w/in class A:
1. open the DB Connection
2. create a ref to class B ~~ my stored proc is in here along w/ transferring the data to a TypeDataSet
3. call class B's method to fill my dataReader by calling a stored proc w/ a returned cursor
4. call class B's method to transpose the dataReader object into a TypeDataSet which is finally returned to class A
5. once i get this filled TypeDataSet object i do the following in my class A code to try and establish a cached set of data that my datagrid can page through:
// Cache application report data
Cache["ReportData"] = rptDataSet;
BindData();
private void PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
{
RptResDataGrid.CurrentPageIndex = e.NewPageIndex;
BindData();
}
private void BindData()
{
SeNTReportTDS tempDataSet = (SeNTReportTDS)Cache["ReportData"];
RptResDataGrid.DataSource = tempDataSet;
RptResDataGrid.DataBind();
}
NOTE: w/o paging, everything works fine, however when i tried to implement this i get the following error:
C:\Inetpub\wwwroot\SeNTReporter\SeNTReportResults.aspx(24,102): error CS0122: 'SeNTReporter.SeNTReportResults.PageIndexChanged(object, System.Web.UI.WebControls.DataGridPageChangedEventArgs)' is inaccessible due to its protection level
help.. please?
so i'm trying to add basic paging to my data grid, under "normal circumstances" w/ a direct SQL query, things would be easy, however i'm using oracle and taking the following steps:
w/in class A:
1. open the DB Connection
2. create a ref to class B ~~ my stored proc is in here along w/ transferring the data to a TypeDataSet
3. call class B's method to fill my dataReader by calling a stored proc w/ a returned cursor
4. call class B's method to transpose the dataReader object into a TypeDataSet which is finally returned to class A
5. once i get this filled TypeDataSet object i do the following in my class A code to try and establish a cached set of data that my datagrid can page through:
// Cache application report data
Cache["ReportData"] = rptDataSet;
BindData();
private void PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
{
RptResDataGrid.CurrentPageIndex = e.NewPageIndex;
BindData();
}
private void BindData()
{
SeNTReportTDS tempDataSet = (SeNTReportTDS)Cache["ReportData"];
RptResDataGrid.DataSource = tempDataSet;
RptResDataGrid.DataBind();
}
NOTE: w/o paging, everything works fine, however when i tried to implement this i get the following error:
C:\Inetpub\wwwroot\SeNTReporter\SeNTReportResults.aspx(24,102): error CS0122: 'SeNTReporter.SeNTReportResults.PageIndexChanged(object, System.Web.UI.WebControls.DataGridPageChangedEventArgs)' is inaccessible due to its protection level
help.. please?