asp.net : paging on a gridview with OleDbDataReader as datasource

grahamor

Hi,

Im passing up data from an access db as a OleDbDataReader object. I then bind this to a gridview. When i try and enable paging i get an error The data source does not support server-side data paging.

Is there an easy workaround for this ? Thanks

public static OleDbDataReader connectDb(string sql)
    {
        //create the database connection
        OleDbConnection aConnection = new OleDbConnection(dbConnection);

        //create the command object and store the sql query
        OleDbCommand aCommand = new OleDbCommand(sql, aConnection);

        aConnection.Open();

        OleDbDataReader aReader = aCommand.ExecuteReader();

        return aReader;
        
        aConnection.Close();
    }

nialo

Your using a datareader instead of a dataset. switch to a dataset and it should work fine.

grahamor

I cant seem to convert my OleDbDataReader to a dataset, do you know how i can do this?

Would i be better connecting to the access db some other way ?

Thanks for the help

nialo

Code adapted...

grahamor wrote: »

Hi,

public static DataSet connectDb(string sql)
    {
        //create the database connection
        OleDbConnection aConnection = new OleDbConnection(dbConnection);

        //create the command object and store the sql query
        OleDbCommand aCommand = new OleDbCommand(sql, aConnection);

        aConnection.Open();

                                         Dataset myDataset = new Dataset() 
         OleDbDataAdapter myAdapter = new OleDbDataAdapter(aCommand) 
         myAdapter.Fill(myDataset) 
 
         return myDataset; 

    }

grahamor

Thanks for all your help Nialo