C# 连接SQL SERVER 数据库进行增删改查

引用：using System.Data;

        using System.Data.SqlClient;

        using System.Configuration;

1，web.config中定义

<connectionStrings>

<!--Data Source=连接数据库端口;Initial Catalog=数据库名称;Uid=账号;Pwd=密码;-->
    <add name="c_conn" connectionString="Data Source=10.1.0.37;Initial Catalog=lsCommon;Uid=lswfUser;Pwd=123456;" />
  </connectionStrings>

//获取连接的数据库信息     

//"Data Source=10.1.0.37;Initial Catalog=lsCommon;Uid=lswfUser;Pwd=123456";

public string conn= ConfigurationManager.ConnectionStrings["c_conn"].ConnectionString;

//插入数据信息

public static void AddSQL()

{      

        string sqlStr = "insert into userinfo (userid, username, sex) values ('001', '张三', '男');";

        var con = new SqlConnection(conn);