Please Help!!! Opening Multiple DataAdapters at same time Gives error
-
Hi, I am using System.Threading namespace as I want to continuously fetch some data from the server and give some notification to the user. I am using SQlDataAdapter,dataset and sqlcommand to fill multiple tables in the dataset. Along with this I also want the user to do his normal work on the software. At that time if he performs another operation where another Sqldataadapter,dataset and sqlcommand is used it gives error while setting commandtext property in the sqlcommand. the error is "Sql Command is busy fetching data" How to overcome this error? Thanks Tasnim
-
Hi, I am using System.Threading namespace as I want to continuously fetch some data from the server and give some notification to the user. I am using SQlDataAdapter,dataset and sqlcommand to fill multiple tables in the dataset. Along with this I also want the user to do his normal work on the software. At that time if he performs another operation where another Sqldataadapter,dataset and sqlcommand is used it gives error while setting commandtext property in the sqlcommand. the error is "Sql Command is busy fetching data" How to overcome this error? Thanks Tasnim
i believe you should use a separate Connection for the separate thread. does that help? Regards, Serge (Logic Software)