Oracle 存储过程
CREATE OR REPLACE PROCEDURE P_DPCXSP
(
ARTICLE IN VARCHAR,
FAM OUT sys_refcursor
)
IS
BEGIN
open FAM FOR select * from defarticle where article=ARTICLE;
END P_DPCXSP;
C# 按钮查询代码
OracleConnection cons = new OracleConnection("Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=服务器IP)(PORT=1521))" + "(CONNECT_DATA=(SERVICE_NAME=server_name)));" + "User Id=use_id;Password=passw;");
cons.Open();
OracleCommand dc = new OracleCommand("P_DPCXSP",cons);
dc.CommandType = CommandType.StoredProcedure;
dc.Parameters.Add("ARTICLE", OracleDbType.NVarchar2).Direction=ParameterDirection.Input;
过程参数赋值
dc.Parameters["ARTICLE"].Value = this.textBox1.Text.ToString();
过程参数输出
dc.Parameters.Add("FAM", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
OracleDataAdapter da = new OracleDataAdapter(dc);
DataSet ds = new DataSet();
da.Fill(ds);
判断查询的结果集是否为空
if (ds.Tables[0].Rows.Count > 0)
{
label3.Text = ds.Tables[0].Rows[0][4].ToString();
}
else
{
label3.Text = "暂时没有查询到信息";
}
查询结果显示到gridview中;
this.dataGridView1.DataSource = ds.Tables[0];
cons.Close();