C#程序连接SqlServer

首先将文字描写的地方以及host和post补全，一定要对应好，切记 切记
使用nuget搜索SqlClient添加，就可以使用下面那些类了。

 string connString = "Data Source = host,post;" +
                   "Persist Security Info=True;" +
                   "Initial Catalog="数据库名称";" +
                   "Integrated Security=false;" +
                    "User ID= 数据库用户名;" +
                   "Password= 数据库密码;";

也可以封装一个方法

        public static SqlConnection GetConnetion()
        {
            string connString = "Data Source = ;" +
               "Persist Security Info=True;" +
               "Initial Catalog= ;" +
               "Integrated Security=false;" +
               
               "User ID=;" +
               "Password= ;";

            return new SqlConnection(connString);
        }

连上数据库就操作呗，直接上代码了

 public static int GoInsert(Tenc tenc)
        {
            string sql = "insert into T_test(date,city,pv,uv) values(" +
            "'" + tenc.Date + "'" + "," + "'"+tenc.City +"'"+ "," + tenc.Pv + "," + tenc.Uv + ")";
            
            SqlConnection sqlConnection =  DataBase.GetConnetion();
            sqlConnection.Open(); //连接数据库
            SqlCommand sqlCommand = new SqlCommand(sql,sqlConnection);
            return sqlCommand.ExecuteNonQuery(); //执行sql
           
        }