c#oracle数据库操作类,Oracle数据库操作类（c#）-.NET教程,C#语言

用oracleconnection连接oracle

在web.config中配置

public system.data.oracleclient.oracleconnection cnn;

///

/// 打开数据库连接

///

public void open()

{

cnn=new oracleconnection(system.configuration.configurationsettings.appsettings["oracle"]);

cnn.open();

}

///

/// 打开数据库连接，返回cnn

///

public oracleconnection opencnn()

{

cnn=new oracleconnection(system.configuration.configurationsettings.appsettings["oracle"]);

cnn.open();

return(cnn);

}

///

/// 关闭数据库连接

///

public void close()

{

cnn.close();

}

///

/// 返回dataset

///

///

///

///

public dataset getdataset(string cmdstring,string tablename)

{

open();

oracledataadapter myda =new oracledataadapter();

myda.selectcommand = new oraclecommand(cmdstring,cnn);

dataset myds =new dataset();

myda.fill(myds,tablename);

close();

return myds;

}

///

/// 返回oledbdatareader

///

///

///

public oracledatareader getdatareader(string cmdstring)

{

open();

oraclecommand mycmd =new oraclecommand(cmdstring,cnn);

oracledatareader mydr =mycmd.executereader();

return mydr;

}

///

/// 返回影响数据库的行数

///

///

///

public int executesql(string cmdstring)

{

open();

oraclecommand mycmd =new oraclecommand(cmdstring,cnn);

int cmd =mycmd.executenonquery();

close();

return cmd;

}

///

/// 邦定drodownlist

///

/// 控件名

/// 连接字符串

/// 表名

/// 提供文本内容的数据源字段

/// 为列表项提供值的数据源字段

public void drolist(dropdownlist drodlist,string sql,string tablename,string datatextfd,string datavaluefd)

{

open();

oracledataadapter myda =new oracledataadapter(sql,cnn);

myda.selectcommand.commandtype = commandtype.text;

dataset myds =new dataset();

try

{

myda.fill(myds,tablename);

drodlist.datasource = myds.tables[tablename];

drodlist.datatextfield = datatextfd;

drodlist.datavaluefield = datavaluefd;

drodlist.databind();

}

catch(exception e)

{

response.write(e.message);

}

finally

{

close();

}

}