c#.net(B/s)读取默认配置文档内容及连接数据库

最新推荐文章于 2016-07-27 20:03:21 发布

nnsword

最新推荐文章于 2016-07-27 20:03:21 发布

阅读量1k

点赞数

分类专栏： Asp.net 文章标签：文档 string 数据库

本文链接：https://blog.csdn.net/nnsword/article/details/1911598

版权

Asp.net 专栏收录该内容

55 篇文章 0 订阅

订阅专栏

1.读取默认文档中connectionStrings内的name=sqlconnectingstring的connectionString值
string sqlstr = System.Configuration.ConfigurationManager.ConnectionStrings["sqlconnectingstring"].ConnectionString;

２.access
public static OleDbConnection createconn()
    {
        string accpath = System.Configuration.ConfigurationManager.ConnectionStrings["dbpath"].ConnectionString;
        accpath = System.Web.HttpContext.Current.Server.MapPath(accpath);
        OleDbConnection accessconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + accpath);
        return accessconn;
    }

3.mssql
public static SqlConnection sqlcreate()
    {
        string sqlstr = System.Configuration.ConfigurationManager.ConnectionStrings["sqlconnectingstring"].ConnectionString;
        SqlConnection sqlconn = new SqlConnection(sqlstr);
        return sqlconn;
    }
别忘了引用数据库操作类