| hich would generate an exception.
另外关闭连接的时候你应该预防的是确保连接对象非空。当实例化连接时出现错误，它将是null，而你确信不会试图关闭一个无效的连接，它应该会产生异常。
This example showed how to use a SqlConnection object with a SqlDataReader, which required explicitly closing the connection. However, when using a disconnected data model, you don''''t have to open and close the connection yourself. We''''ll see how this works in a future lesson when we look at the SqlDataAdapter object.
这个例子演示了如何通过SqlDataReader使用SqlConnection对象，它需要显式的关闭连接。然而，当使用断开连接模型的时候，并不需要你自己打开并关闭连接。当以后讲到SqlDataAdapter对象的时候我们将会看到它如何使用。
Summary
总结
SqlConnection objects let other ADO.NET code know what data base to connect to and how to make the connection. They are instantiated by passing a connection string with a set of key/value pairs that define the connection. The steps you use to manage the lifetime of a connection are create, open, pass, use, and close. Be sure to close your connection properly when you are done with it to ensure you don''''t have a connection resource leak.
SqlConnection对象让其它的ADO.NET代码知道连接哪一个数据库并且如何连接。它们通过传递一个使用键/值对定义的连接字符串来实例化。使用来管理连接的声明周期是创建、打开、传递、使用和关闭。当你完成了工作后确信适时的关闭连接，避免遇到连接资源泄漏的问题。
I hope you enjoyed this lesson and invite you to view the next one in this series, Lesson 03: The SqlCommand Object.
For further questions, you are welcome to participate in the C# Station Discussion Forums.
Your feedback is very important and I appreciate any constructive contributions you have. Please feel free to contact me for feedback or comments you may have about this lesson.
<< 上一页 [11] | 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 