Hi Ashwani,
Making a dataset of all your records is in my opinion not the right way,
You can make smaller tables using by instance in the select clause the
"Where"
One of the posibilities is let the user first select it using a combobox
where you only did fill a dataset with the showmember and the keyfields from
a parent database table
Just a thought, but there are of course thousands of other ways.
I don't think that using the datareader will help you much further, you have
to do a lot of work yourself
- making the dataset
- making the datatable
- making the columns
- creating the keys
- read all rows
- filling item by item all the rows
- add the rows to the table
and all I forget.
And then I think the result will be the same.
If you don't know how to create a dataset with a fill, that is roughly
written as pseudo
\\\
dim mydataset as new dataset
(connection, dataadapter, and commandbuilder need a prefix as Oledb or SQL)
dim myconnection as new connection("connectionstring")
dim mydataadapter as new dataAdapter("MySQLWhereString",myconnection)
mydatadapter.fill(mydataset)
///
I hope this helps
Cor
It may be a very simple query, but i am stuck with having
millions of record showing instantly in chunks of 100 or
200 record(not a paging concept), in vb i use to bind the
data to ado datacontrol which is binded to datagrid and
data is instantly shown using ado events and methods in a
user friendly manner i.e data is shown and fetched
simultaneously.
In vb.net if i am using dataset and binding that dataset
to grid, the data is not shown till all the records are
fetched and i don't know how to bind it to datareader,
also i don't know how to use threads to achieve this, can
anyone help me out with some piece of code to get me
started.