TAILIEUCHUNG - Using a SqlConnection Object to Connect to a SQL Server Database phần 1

Using a SqlConnection Object to Connect to a SQL Server Database You create a SqlConnection object using the SqlConnection() constructor. This constructor is overloaded | Using a SqlConnection Object to Connect to a SQL Server Database You create a SqlConnection object using the SqlConnection constructor. This constructor is overloaded meaning that there are multiple versions of the constructor that you can call. The SqlConnection constructors are as follows SqlConnection SqlConnection string connectionString where connectionString contains the details for the database connection. You ll learn the details of the connectionString in this section. Assuming you ve imported the namespace you can create a new SqlConnection object using the following statement SqlConnection mySqlConnection new SqlConnection You can then set the details for the database connection using the ConnectionString property of mySqlConnection. For example server localhost database Northwind uid sa pwd sa where server specifies the name of the computer on which SQL Server is running. database specifies the name of the database. uid specifies the name of the database user. pwd specifies the password for the user. Warning For security reasons do not include the username password in your production code. Instead ask the user to enter their name and password-or use integrated security which you ll learn about shortly. One thing you need to bear in mind is that you can set the ConnectionString property only when your Connection object is closed. You can also pass a connection string directly to the SqlConnection constructor. For example string connectionString server localhost database Northwind uid sa pwd sa SqlConnection mySqlConnection new SqlConnection connectionString Or more simply SqlConnection mySqlConnection new SqlConnection server localhost database Northwind uid sa pwd sa You can set an optional connection timeout which specifies the number of seconds that the Open method will wait for a connection to the database. You do this by specifying a connection timeout in your connection string. For example the

• Kỹ thuật lập trình
• kĩ thuật lập trình
• công nghệ thông tin
• lập trình
• ngôn ngữ lập trình
• C Shark
• C#
• sybex c
• sharp database programming
• thủ thuật lập trình
• tư liệu lập trình
• hướng dẫn lập trình
• kĩ năng lập trình
• AutoIT