App not repsonding-get data from SQL
-
Hi. I am new to the programming bussiness. I have a urgent question.I am still working on .net 2003. When i am on a windows form, and run a select statement from sql to retrieve data, about 5000 records, the app is displaying in the task manager - "Not Responding" and it is opening a new instance of that. When it has retrieved the data, it is then running again and the other instance dissapears. Can smeone please help. This app must write about 50 000 records in to sql in one stage after it has checked in the db for duplications, and cannot display that it is not responding. Thanks
-
Hi. I am new to the programming bussiness. I have a urgent question.I am still working on .net 2003. When i am on a windows form, and run a select statement from sql to retrieve data, about 5000 records, the app is displaying in the task manager - "Not Responding" and it is opening a new instance of that. When it has retrieved the data, it is then running again and the other instance dissapears. Can smeone please help. This app must write about 50 000 records in to sql in one stage after it has checked in the db for duplications, and cannot display that it is not responding. Thanks
Hi Usually a program runs in a sequential manner (in a single thread) it means that each line of code should be executed and returns before the program flow can proceed. Sometimes it takes some time for a command to be executed ( like you said,when a SQL statement is executing) and since your program is waiting (busy) during this operation if you want to ask its status using Task Manager,you will get "Not responding" there are some ways that you can avoid this situation. You can execute a command Asynchronously ( in another thread.) This way your command will be executed in another thread (sequence of program flow) and you will be notified when the command execution is ended. Regards