C#中如何调用存储过程,函数?

[kutou]

cmd= new OleDbCommand("insertdatatotable", conn);
cmd.CommandType = CommandType.StoredProcedure;
par1=new OleDbParameter();
par2=new OleDbParameter();
par1.ParameterName="@operator_num";
par2.ParameterName="@code_num";
par1.Size =8;
par2.Size=8;
par1.OleDbType=OleDbType.VarChar;
par2.OleDbType=OleDbType.VarChar;
par1.Value="12345678";
par2.Value="87654321";
cmd.Parameters.Add(par1);
cmd.Parameters.Add(par2);
我把两个参数加进去了.可是我要怎么运行函数"insertdatatotable"呢?
调用存储过程是不是也一样?

[chanet]

给你一个 ADO.NET 的参考:
http://www.zdnet.com.cn/developer/tech/story/0,2000081602,39137928,00.htm

[kutou]

最后执行cmd.executereader()时就出错了,为什么？
我是参考oleDB连接sql做的，是不是调用oracle的存储过程和调用sql中的存储过程有什么不同？望指教！！！！！！！！！！！

[LGQDUCKY]

给个例子
SqlCommand sampleCMD = new SqlCommand("Package.ProName", myConn);
sampleCMD.CommandType = CommandType.StoredProcedure;
...

myC
Dim myConnection As New OracleConnection(connectstring)
myConnection.Open()
Dim myCommand As New OracleCommand()
myCommand.Connection = myConnection
myCommand.CommandType = CommandType.StoredProcedure

myCommand.CommandText = "packagename.procedurename"

myCommand.Parameters.Add("CURSORname", OracleType.Cursor).Direction = ParameterDirection.Output

Dim myReader As OracleDataReader
myReader = myCommand.ExecuteReader()

ListBox2.DataSource = myReader
ListBox2.DataTextField = "PROJECTNAME"
ListBox2.DataBind()
ListBox2.SelectedIndex = 0

myReader.Close()
myConnection.Close()
myReader = Nothing
myConnection = Nothing

[kutou]

谢谢chanet,我去看看先！

[kutou]

他的连接都给删了，看不到了啊！

[好运]

mark