hi,
i have some problem (delay) in filling tableadapter.
when i fill the adapter it takes lil bit time to fill the adapter and then diplaying rows on datagrid in for examle.
tableadapter.fill(dataset1.datatable)
datagridview1.datasource=tableadapterbindingsource;
the code above take arround 10 sec to fill <1000 rows because once it complete with retrievel then the whole datset display on grid.
i need a piece of code for asynchronic call for fill method so that as soon as its start fatching rows from table same starts displaying on grid with a row counter and same can be stopped any time during retrievel.
thanks in advance
fazy
Loading
faraz akramPosted Jan 4, 2010, 12:25 AM
My friend u did't understand my question, i am bound to use datset so the datareader is out of question, as u said "u can use datatable" that can be considered, but for that i need the above code to be drill down more with tableadapter.
secondly i need to show the retrievel as soon as the adapter start filling mean while the datagrid also strat showing the rows with incremental counter of rows and with a cancel button to stop the retrievel any time .
asynchronous DATASET CALLS (working with threads)
thanks in advance