开启数据库连接服务
using System.Data.SqlClient;
SqlConnection conn = new SqlConnection();
string connectionString="server=.;database=Sql;uid=sa; pwd=123456";
conn.ConnectionString = connectionString;
conn.open();
到这一步后,可以通过命令查看下数据库的连接状态:
Console.Write(conn.State.ToString());
执行SQL语句
string sqlStr = "SELECT * FROM table2";
SqlCommand cmd = new SqlCommand(); cmd.Connection = conn;
cmd.CommandText = sqlStr; cmd.CommandType = CommandType.Text;
int i = Convert.ToInt32(cmd.ExecuteNonQuery());
Console.Write("总共有" + i.ToString() + "条数据");
关闭相关连接和服务
所有的一切做完后,要记得关闭数据库连接
conn.Close();
联系客服