C#和asp.net中添加SQL连接的2个办法

来源：互联网发布：诸暨行知小学的资料编辑：程序博客网时间：2024/06/07 16:55

C#的办法就是用sqlconnectionstringbuilder来构建，个人认为这个方法比较简单，不需要太多的操作，只需要按提示把字段定义好就可以

其中：IntegratedSecurity设置为true为用windows登陆账号验证，为false则需要自己添加用户名和密码

private static SqlConnection buildConnection()        {            SqlConnection myconnection = new SqlConnection();            SqlConnectionStringBuilder con = new SqlConnectionStringBuilder();            con.DataSource = "127.0.0.1";            con.IntegratedSecurity = true;            con.InitialCatalog = "test";            try            {                myconnection = new SqlConnection(con.ConnectionString);            }            catch            {                Console.WriteLine("Connection error");            }            return myconnection;        }

ASP.NET办法是朋友提供的，在web.config里面预设好

<appSettings>    <add key="datasourceConnetstring" value="Data Source=127.0.0.1;Initial Catalog=HR;User ID=HR;pwd=hr" />  </appSettings>

接着在connection中引用web.config的变量

public static SqlConnection getconnection()         {            System.Configuration.AppSettingsReader aps = new AppSettingsReader();            SqlConnection sqlconn=null;            try            {                string dataconnectionstring = aps.GetValue("datasourceConnetstring", typeof(string)).ToString();                sqlconn = new SqlConnection(dataconnectionstring);                if (sqlconn.State == ConnectionState.Broken)                {                    sqlconn.Close();                }                if(sqlconn.State == ConnectionState.Closed )                {                    sqlconn.Open();                }                          }catch(SystemException ex)            {                sqlconn.Close();                sqlconn.Dispose();              }            return sqlconn;        }

两个办法都测试可行！