1、在App.config里面定义连接字符串:
<connectionStrings>
<add name="mysqlserver" connectionString="server=.\SQLEXPRESS;database=master;integrated security = true;"/>
</connectionStrings>
2、SQLHelper.cs :
//定义一个连接字符串
//readonly 修饰的变量,只有在初始化的时候赋值
private static readonly string connStr = ConfigurationManager.ConnectionStrings["mysqlserver"].ConnectionString;
//1.执行增、删、改的方法insert、delete、updata
//(ExecuteNonQuery())
public static int ExecuteNonquery(string sql,CommandType type,params SqlParameter[] pars)
{
using(SqlConnection conn = new SqlConnection(connStr))
{
using(SqlCommand cmd =new SqlCommand(sql, conn))
{
if(