数据库操作类是一个static类
public static class CDataAccess
{
public static string strConnectString=System.Configuration.ConfigurationManager.AppSettings["Connstr"];
public static OracleConnection Conn = new OracleConnection(strConnectString);
。。。。
获取结果集的静态方法,如:
public static bool OpenDataSet(DataSet dsResult, string strTableName, string strSQL, CSQLParams[] ParamNames, Object[] ParamValues)
{
try
{
OracleCommand OraCommand = new OracleCommand(strSQL, Conn);
AssignCommandParams(OraCommand, ParamNames, ParamValues);
OracleDataAdapter daSQL = new OracleDataAdapter(OraCommand);
daSQL.Fill(dsResult, strTableName);
return true;
}
catch (Exception E)
{
throw E;
}
finally
{
if (Conn.State == ConnectionState.Open) Conn.Close();
}
}
public static class CDataAccess
{
public static string strConnectString=System.Configuration.ConfigurationManager.AppSettings["Connstr"];
public static OracleConnection Conn = new OracleConnection(strConnectString);
。。。。
获取结果集的静态方法,如:
public static bool OpenDataSet(DataSet dsResult, string strTableName, string strSQL, CSQLParams[] ParamNames, Object[] ParamValues)
{
try
{
OracleCommand OraCommand = new OracleCommand(strSQL, Conn);
AssignCommandParams(OraCommand, ParamNames, ParamValues);
OracleDataAdapter daSQL = new OracleDataAdapter(OraCommand);
daSQL.Fill(dsResult, strTableName);
return true;
}
catch (Exception E)
{
throw E;
}
finally
{
if (Conn.State == ConnectionState.Open) Conn.Close();
}
}