文章提供这款数据库教程连接代码是一款asp教程.net 与 oracle,sql server,access 数据库类哦, 如果你是asp.net教程开发者那你就爽了啊,这是一款利用了.net可以与oracle,sql server,access 进行连接哦,如果你用其这一种数据库就可以直接使用了,同时也解决了关于各种数据库连接问题。
using system;
using system.collections;
using system.collections.specialized;
using system.data;
using system.data.sqlclient;
using system.data.oledb;
using system.data.oracleclient;
using system.configuration;
using system.reflection;namespace systemframework.dal
{
/**//// <summary>
/// all rights reserved
/// 数据访问基础类
/// 用户可以修改满足自己项目的需要。
/// </summary>
public class databaselayer
{
//数据库连接字符串(web.config来配置)
//<add key="connectionstring" value="server=127.0.0.1;database=database;uid=sa;pwd=" />
private string connectionstring;
public string conntionstring
{
get
{
return connectionstring ;
}
set
{
connectionstring = value;
}
}public databaselayer(string strconnect,string datatype)
{
this.conntionstring = strconnect;
this.dbtype = datatype;
}public databaselayer()
{
this.connectionstring = configurationsettings.apps教程ettings["connectionstring"] ;
this.dbtype = configurationsettings.appsettings["datatype"] ;
}/**//// <summary>
/// 数据库类型
/// </summary>
private string dbtype;
public string dbtype
{
get
{
if ( dbtype == string.empty || dbtype == null )
{
return "access";
}
else
{
return dbtype;
}
}
set
{
if ( value != string.empty && value != null )
{
dbtype = value;
}
if (dbtype ==string.empty || dbtype == null)
{
dbtype = configurationsettings.appsettings["datatype"];
}
if ( dbtype == string.empty || dbtype == null )
{
dbtype = "access";
}
}
}
首页 1 2 3 4 5 6 7 8 末页