Asynchronic Dataset calls

Question

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 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

faraz akram · Answer

thanks for the reply  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