Dear Expert,

The book I bought is Chinese version, so the page in which I have problems is not matched the English version. I just can say that the page is in the Chapter 10.3 Visual Studio and Data Access (this is my interpretation from Chinese to English). In this chapter I learned how to use Dataset as a control to manipulate the data.

What is my problem? When I used this way to manipulate the data (C# and Microsoft SQL Server), I found I cannot control the object – “sqlConnection”. That means I cannot use “sqlConnection.close” to close the connection between my application and Microsoft SQL Server. I try to find the code of “sqlConnection.open”, but I did not find anything about the action of this object. In SQL Server I found once I run my application that uses this object to manipulate the data, the connection will not disconnect until the application is shut down even if I explicitly use the code – “ sqlconnection.close”. So what is the principle of this kind of objects, can I control them?

please quote using System.Data.SqlClient;


    ABeen

I understand your problem.
I also don't think the solution given by the last post can solve the problem - adding "using System.Data.SqlClient" will not help closing the SQL connection.

I also don't know how to close the SQL connection before the application quits to stop it automatically.
I reviewed all my coding samples, and found out that I haven't thought about closing the SQL connection before.
I don't know how to close the connection manually in the code. Sorry

Isnt using the USING statement helpful in this regard?