Thread: About Dataset
View Single Post
 
Old April 5th, 2006, 12:25 PM
LeoG LeoG is offline
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default About Dataset

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?