1. 连接数据库
1. 创建SqlConnection对象:SqlConnection sqlConnection = new SqlConnection();
2. 创建连接字符串:Server=服务名称;Uid=用户名;Pwd=密码;DataBase=库名
string sqlConnectionString = @"Server=LocalHost\KAITESTSQLSERVER;Uid=sa;Pwd=1234;DataBase=KaiTest";
3. 设置SqlConnection对象的ConnectionString属性:sqlConnection.ConnectionString = sqlConnectionString;
4. 打开数据库:sqlConnection.Open();
2. 执行Sql语句:
1. 创建SqlCommand对象:SqlCommand sqlCommand = new SqlCommand();
2. 设置SqlCommand对象的Connection属性:sqlCommand.Connection = sqlConnection;
3. 设置SqlCommand对象的CommandText属性:sqlCommand.CommandText =Sql语句字符串
4. 执行非查询Sql语句,能够返回受影响的行数sqlCommand.ExecuteNonQuery();
5. 执行查询Sql语句,并返回第一个单元格数据:object result=sqlCommand.ExecuteScalar();
6. 执行查询Sql语句,遍历结果集:
1. 设定查询语句:sqlCommand.CommandText = "Select * From Kai";
2. 创建SqlDataReader对象:SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
3. 移动指针,判断是否有数据:while(sqlDataReader.Read()==true)
4. 使用sqlDataReader[字段名称]读取数据:Console.WriteLine((int)