I have devloped an application(windows), I'm inserting data from two tables in to An Excel sheet. Table have thousands of entries. Everything is working smooth.
Since tables have thousands of record so while joining it takes minutes . I'hv used progress bar to show progress but when I click on the Join button my form gets white blank screen it remains white untill all records gets insert.
I'm matching records simply using select * where (condition)and(condition)and(condition).
So help me to show the progress bar while background process...
also help me to increse speed of opertion (may i use select with LIKE to speed up??????)