数据库字符串
web.config中
<connectionStrings>
<add name="OraclAdoConnection" connectionString="Data Source=dbname;Persist Security Info=True;User ID=username;Password=psw;Unicode=True"/>
</connectionStrings>
后台处理
public class DBOper
{
private static string connectionstring = ConfigurationManager.ConnectionStrings["OraclAdoConnection"].ConnectionString;
private DataSet ds = null;
private OracleDataAdapter oda = null;
private OracleConnection con = null;
public OracleConnection GetConnection()
{
return new OracleConnection(connectionstring);
}
//返回DataSet
public DataSet GetDataSet(string sql)
{
using (con = GetConnection())
{
ds = new DataSet();
oda = new OracleDataAdapter(sql, con);
oda.Fill(ds);
}
return ds;
}
//返回DataTable
public DataTable GetDataTable(string sql)
{
using (con = GetConnection())
{
ds = new DataSet();
oda = new OracleDataAdapter(sql, con);
oda.Fill(ds);
}
return ds.Tables[0];
}
//更新
public void Update(string sql)
{
using (con = GetConnection())
{
con.Open();
OracleCommand cmd = new OracleCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
}
}
//ExecuteNoQuery
public int ExecuteNoQuery(string sql)
{
int count;
using (con = GetConnection())
{
con.Open();
OracleCommand cmd = new OracleCommand(sql, con);
count= cmd.ExecuteNonQuery();
con.Close();
}
return count;
}
//ExecuteScalar
public object ExecuteScalar(string sql)
{
object count;
using (con = GetConnection())
{
con.Open();
OracleCommand cmd = new OracleCommand(sql, con);
count = cmd.ExecuteScalar();
con.Close();
}
return count;
}
}