C# Sql Server、Access、My SQL 数据库连接配置

【一、Sql Server配置方法：】

[1.应用程序配置方法]

<connectionStrings>
    <add name="connStr"  connectionString="Data Source=.\mssqlserver2;Initial Catalog=DBName;Integrated Security=True"/>
</connectionStrings>

获取连接字符串方法:

public static readonly string ConnectionStringMSSQL = 
ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

[2.网站配置方法]

<appSettings>
<add key="ConnectionString" value ="server=127.0.0.1;database=db1;uid=sa;pwd=pwd" />
</appSettings>

获取连接字符串方法:

protected readonly static string connectionString = 
System.Configuration.ConfigurationManager.AppSettings["SQL_ServerString"].ToString();

引入命名空间：

using System.Data.SqlClient;

连接通道对象：

SqlConnection conn = new SqlConnection();

【二、Access配置方法：】

<appSettings>
	<add key="AccessString" value="【Provider=Microsoft.Jet.OLEDB.4.0;Data Source=】||【Provider=Microsoft.ACE.OLEDB.12.0;Data Source=】"/>
	<add key="AccessDBPath" value="~/App_Data/a.accdb"/>
</appSettings>

获取连接字符串方法:

protected readonly static string connStr = 
System.Configuration.ConfigurationManager.AppSettings["AccessString"].ToString() + 
System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["AccessDBPath"]);

引用命名空间：

using System.Data.OleDb;

连接通道对象：

OleDbConnection conn = new OleDbConnection();

【把查询结果加载到网页】

string sql = "select * from YongHu";
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
//DataTable
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();

虚拟路径获得物理路径：

System.Web.HttpContext.Current.Server.MapPath("\\app_data\\");

三、【My SQL 配置方法】

<appSettings>
 <add key="MySQLString" value="server=127.0.0.1;database=Test;uid=root;pwd=lcl19941001"/>
</appSettings>

获取连接字符串方法:

protected static readonly string connStr = 
System.Configuration.ConfigurationManager.AppSettings["MySQLString"].ToString();

注意：在引用命名空间前，要引入程序集：MySql.Data.dll

引用命名空间：

using MySql.Data.MySqlClient;

连接通道对象：

MySqlConnection conn = new MySqlConnection();