c#连接sql server

C#连接sql Server数据库

1.建立SqlConnection对象以连接数据库   SqlConnection mySqlConnection = new SqlConnectio("server=10.2.24.206;database=NorthWind;uid = sa;pwd = a");

2.建立SqlCommand对象   SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

3.设置SqlCommand对象的CommandText属性   mySqlCommand.CommandText = "select * from Customers where CustomerID = 'ALFKI'";

4.打开SqlConnection对象   mySqlConnection.Open();

5.运行select语句    SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader(); 6.用SqlDataReader对象读取    mySqlDataReader.Read();

7.显示SqlDataReader对象中的列值    Console.WriteLine(mySqlDataReader["CustomerID"]);    Console.WriteLine(mySqlDataReader["CompanyName"]);

8.关闭SqlDataReader对象    mySqlDataReader.Close();

9.关闭SqlConnection对象   mySqlConnection.Close();