c# 连接sqlserver数据库

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WpfApplication1
{
    public static class SqlServerManager
    {
        private static string strConn = "";
        public static void Init()
        {
            //连接字符串有很多种方式，如下
            //当server=.或localhost都代码本地,data source一样

            //windows身份验证
            //strConn = "server=.;database=SZSQ;integrated security=SSPI";
            //strConn = "server=localhost;database=SZSQ;integrated security=SSPI";
            //strConn = "server=;database=SZSQ;integrated security=SSPI";
            //SQL Server身份验证
            //strConn = "server=.;database=SZSQ;uid=sa;pwd=123";
            //strConn = "data source=.;database=SZSQ;uid=sa;pwd=123";
            //strConn = "data source=.;initial catalog=SZSQ;uid=sa;pwd=123";

            strConn = "Server=localhost;DataBase=cxnSql;uid=sa;pwd=123";
        }

        public static void OpenConnect()
        {
            using(SqlConnection conn = new SqlConnection(strConn))
            {
                try
                {
                    conn.Open();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }

        public void SelectCommand()
        {
            //查询cxnTable表中的name字段
            string strCmd = "select name from cxnTable";

            using(SqlConnection conn = new SqlConnection())
            {
                //表示Sql server的操作语句
                SqlCommand sqlComm = new SqlCommand(strCmd,conn);
                conn.Open();
                //ExecuteReader函数：执行sql语句返回SqlDataReader
                //通过SqlDataReader读取数据
                SqlDataReader reader = sqlComm.ExecuteReader();

                string msg = "";
                while (reader.Read())
                {
                    msg += "name:" + reader["name"] + "\n";
                }

                reader.Close();
                conn.Close();//可写可不写，因为using会自动调用Dispose和Close（习惯写上了,如果不使用using需要写上）
            }
        }

        public void UpdateCommand()
        {
            //更新cxnTable表中的name字段  ID=1的这行
            string newName = "小明";
            string strCmd = "UPDATE cxnTable SET name = '" + newName + "' WHERE ID = 1";
            int rowNum = 0;
            using(SqlConnection conn = new SqlConnection())
            {
                SqlCommand comm = new SqlCommand(strCmd,conn);
                rowNum = comm.ExecuteNonQuery();//返回受影响的行数
                conn.Close();
            }
        }



    }
}