none
paging datareader/dataset RRS feed

  • Question

  • Hi,

     

    I read first 500 rows into dataset (using datareader) and show it to the user by datagrid.

    when the users scroll till the end of datagrid, i want to append more rows to the dataset

     

    i got the next 500 rows in temporary dataTable and used dataset.Merge()

    this does not refresh the rows in the datagrid.

     

    private void getMoreRows()

    {

    System.Data.DataTable dsTemp = new DataTable();

    dsTemp = GetTable(OdbcDR);

    originalDataSet.Merge(dsTemp);

    originalDataSet.AcceptChanges();

    }

     

    GetTable()

    {

     reads/returns the number of from in to datatable.

    }

     

    I am new to C#, i am assuming i have done some wrong here.

     

    Tuesday, July 24, 2007 11:26 AM

Answers

All replies