***********************C#连接数据库7个步骤:增删改*******************
1.导包
using System.Data.SqlClient;
2.准备连接字符串
String conStr = "Data Source=localhost;Initial Catalog=myschool;Integrated Security=True";
3.准备连接对象
SqlConnection con = new SqlConnection(conStr);
4.打开连接
con.Open();
5.准备sql语句
String sql = "增删改的语句";
6.准备执行sql语句的对象
SqlCommand com = new SqlCommand(sql,con);
7.执行sql语句
com.ExecuteNonQuery();
8.关闭连接
con.Close();
***********************C#连接数据库7个步骤:查询*******************
1.导包
using System.Data.SqlClient;
2.准备连接字符串
String conStr = "Data Source=localhost;Initial Catalog=myschool;Integrated Security=True";
3.准备连接对象
SqlConnection con = new SqlConnection(conStr);
4.打开连接
con.Open();
5.准备sql语句
String sql = "查询的语句";
6.准备执行sql语句的对象
SqlCommand com = new SqlCommand(sql,con);
7.执行sql语句
SqlDataReader r = com.ExecuteReader();
8.读取数据
while (r.Read()) {
int id = (int)r["结果集字段名"];