thank you for you advise
My Software is Running in a hospital with one Server and 25 Client. The query execute with in SQL In Less then 3 Second. while executing in .net some time it Time Out. I Want to Know What are the other reason of Query timeout.
The most common reason I've seen is the ARITHABORT setting - it's ON by default in SSMS, but OFF by default in .NET connections. Adding SET ARITHABORT ON to the start of your stored procedure often helps.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
I have a VS 2013 C# windows form application that binds a details view then a datagridview with an Access Database. I want to use SQL Light instead. There does not seem to be a simple procedure to click details view on the data source with SQL Light and drag the table onto the form as there is with Access. Can someone refer an article that explains how to accomplish this with C#?
Thank you for the links, Richard. I can't find what I am looking for. I have a windows form connected to an Access Database. Building the form was essentially drag and drop. I want to display a single record from a Sqlite database in an array of textboxes. VS will build all this when I select details view from the table, then drag the table onto the form. A data navigator is also installed. Then I drag a datagridview onto the form and the VS designer links everything together. So I don't really write any code. I installed the Sqlite toolbox, and I can add a datagridview easily. But not details. Since there seems to be nothing in VS to do this for Sqlite, can I simply change the connection string to the existing form that connects to Access?