前言：在处理asp.NET程序问题时经常遇到用户填写的mssql数据库连接字符串代码是错误的,每次都要在网上搜索一番,本次整理了常见的asp.NET程序连接mssql数据库的字符串使用方法；
在Web.Config中创建连接字符串：
1、asp.net连接Access数据库代码：

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\grade.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

2、asp.net连接mssql数据库代码：

<add name="sampleConnectionString" connectionString ="server=.\SQLEXPRESS;database=sample;uid=sa;pwd=123456;" providerName ="System.Data.SqlClient"/>

<add name ="testConnectionString" connectionString ="Data Source=.\SQLEXPRESS;Initial Catalog=sample;Integrated Security=True;Persist Security Info=True;User ID=sa;Password=123456" providerName ="System.Data.SqlClient"/>

  <connectionStrings>
       <add name="SqlDB" connectionString="Data Source=sql.123.vhostgo.com;Initial Catalog=hmesepims;Integrated Security=False;uid=hmesepims;pwd=ly001112" providerName="System.Data.SqlClient" />
  </connectionStrings>

本文章由301免备案跳转博客整理,转载请注明出处：https://www.zfcdn.xyz/showinfo-12-35842-0.html