C# Programming
11-16-2009, 04:40 AM
hi dudes,
i want to copy a table from an access database to another table on another access database in windows application using c#,what is the best solution,i dont want my application to hang while copying the data;i've tried reading record by record by a simple oledbcommand execute way,but it would take a long time,i have a lot of records in source database,how can i do the copy by using dataset?is using dataset the best solution? how? how can i relate a progress bar to that? i've seen a class named sqlbulk which works for sql databases that copies a large amount of data between tables or databases,but my database is access.i will be thankful for those who do me a favor and give me an answer.
i want to copy a table from an access database to another table on another access database in windows application using c#,what is the best solution,i dont want my application to hang while copying the data;i've tried reading record by record by a simple oledbcommand execute way,but it would take a long time,i have a lot of records in source database,how can i do the copy by using dataset?is using dataset the best solution? how? how can i relate a progress bar to that? i've seen a class named sqlbulk which works for sql databases that copies a large amount of data between tables or databases,but my database is access.i will be thankful for those who do me a favor and give me an answer.