Question

SqlConnection的实例怎么用

Answer 1

我举个例子你就明白了
SqlConnection Conn = new SqlConnection(连接字符串);
Conn.Open();//打开数据库连接
......//执行操作
Conn.Close();//关闭数据库连接

Answer 2

SqlConnection sqlCn = new SqlConnection("Server=localhost;DataBase=数据库名;Integrated Security =SSPI"); //建立数据库实例..
sqlCn.Open();
SqlCommand sqlCm = new SqlCommand();
sqlCm.CommandText = "Insert into database(stuid,stuname) values('333','purana')";
sqlCm.Connection = sqlCn;
sqlCm.ExecuteNonQuery(); //执行sql语句...
Conn.Close();