asp.netÁ¬½ÓoracleÓöµ½µÄ¹ÖÎÊÌâ

SQL code:
C:\Documents and Settings\xjy>sqlplus cust/cust@cust

SQL*Plus: Release 8.1.7.0.0 - Production on ÐÇÆÚÈÕ 1ÔÂ 3 17:59:57 2010

(c) Copyright 2000 Oracle Corporation. All rights reserved.


Á¬½Óµ½:
Oracle7 Server Release 7.2.3.0.0 - Production Release
With the distributed option
PL/SQL Release 2.2.3.0.0 - Production

SQL>


¿Í»§¶ËÊÇwinxp+8.17
·þÎñÆ÷ÊÇSCO UnixWare 7.1.3+ ORACLE7.2.3

ÔÚXPÏÂÓÃVS2005 Á¬½Ó ·þÎñÆ÷
C# code:

//AÓï¾äÈçÏÂ
public DataTable getCust()
{
string sql = "select * from cust";

return new OraDbHelper(connnectionString).ExecuteDataTable(sql, CommandType.Text);

}
//BÓï¾äÈçÏÂ

public DataTable getDh_Art()
{
string sql = "select * from xjy_dh_art";
return new OraDbHelper(connnectionString).ExecuteDataTable(sql, CommandType.Text);
}

public DataTable ExecuteDataTable(string commandText, CommandType commandType, params OracleParameter[] parameters)
{
DataTable data = new DataTable();//ʵÀý»¯DataTable£¬ÓÃÓÚ×°Ôزéѯ½á¹û¼¯
using (OracleConnection connection = new OracleConnection(connectionString))
{