数据库连接

最新推荐文章于 2025-06-25 09:25:21 发布

sqlmlm

最新推荐文章于 2025-06-25 09:25:21 发布

阅读量318

点赞数

分类专栏： webform 文章标签：数据库 sqlserver security class access string

webform 专栏收录该内容

51 篇文章

订阅专栏

1：access连接类
using System.Data.OleDb;
using System.Configuration;
public class ConDB
{
    public ConDB()
    {
    }
    public static OleDbConnection getConnection()
    {
        string connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data/zdhjh.mdb") + ";Persist Security Info=False";
        return new OleDbConnection(connstring);
    }
}
2：sqlserver连接类
<connectionStrings>
<add name="MessageSystemConnectionString" connectionString="Data Source=.;Initial Catalog=MessageSystem;User ID=sa;Password=sa"
   providerName="System.Data.SqlClient" />
</connectionStrings>
/********************************/
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
/// <summary>
/// DB 的摘要说明
/// </summary>
public class DB
{
public DB()
{ }
public static SqlConnection CreateDB()
{
        return new SqlConnection(ConfigurationManager.ConnectionStrings["MessageSystemConnectionString"].ConnectionString);
}
}
/********************************/
<connectionStrings>
        <add name="ConnectionString" connectionString="Data Source=./SQLEXPRESS;AttachDbFilename=|DataDirectory|/Database.mdf;Integrated Security=True;User Instance=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
/***********************************/
public static SqlConnection CreateCon()
{
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
       return con;
}