C# 访问Oracle数据库示例

2024年2月8日发(作者：)

C#访问Oracle数据库示例

首先确保引用了命名空间：

using ;

using Client;

定义连接字符串如下：

private const string ConnectionString = "Data

Source=mydatabase;user=name;password=pwd;"

1.使用OracleCommand执行无参数简单查询，直接写SQL语句或调用存储过程，使用OracleDataReader遍历显示数据，如下：

protected void GetData1(){OracleConnection conn = new

OracleConnection(ConnectionString);

try {();

OracleCommand cmd = new OracleCommand();

tion = conn;

//dText = "select * from TB";

dText = "a";

dType = Procedure;

OracleParameter parameters = new OracleParameter("refOut",

);

ion = ;

(parameters);

OracleDataReader odr = eReader();

while (()){(cleString

1 / 3

(1).ToString() + "

");}();}catch (Exception

ee){(e);}finally {();}}

2.使用OracleDataAdapter执行SQL语句，填充DataSet，遍历显示数据，如下：

protected void GetData2(){OracleConnection conn = new

OracleConnection(ConnectionString);

OracleDataAdapter ad = new OracleDataAdapter("select * from TB", conn);

try {DataSet ds = new DataSet();

(ds);

foreach (DataRow dr in

[0].Rows){(dr["code"].ToString() + "

");}}

catch (Exception ee){(e);}finally {();}}

3.带参数的存储过程，如下：

protected void ViewButton_Click(object sender, EventArgs e){OracleConnection

conn = new OracleConnection(ConnectionString);

try {();

OracleCommand cmd = new OracleCommand();

tion = conn;

dText = "abyid";

dType = Procedure;

OracleParameter[]parameters

={newOracleParameter("rid",),new OracleParameter("refOut",

)};

parameters[0].Direction = ;

2 / 3

parameters[0].Value = edValue;

parameters[1].Direction = ;

(parameters[0]);

(parameters[1]);

OracleDataAdapter da = new OracleDataAdapter(cmd);

DataTable dt=new DataTable();

(dt);

= [0][1].ToString();}catch (Exception

ee){(e);}finally {();}}

3 / 3