如何传递datatable作为输入到C＃中的过程？ [英] How to Pass datatable as input to procedure in C#?

问题描述

我写了存储过程插入数据到数据库表，但我没有得到如何传递数据到存储过程请告诉如何使用它。

I am wrote stored procedure to Insert data into database table but i am not getting how to pass datatable to stored procedure kindly tell how to use it.

CREATE OR REPLACE PROCEDURE PR_SREE_TEST(p_recordset In SYS_REFCURSOR) IS

Contrac_rc SREE_TEST%rowtype;
BEGIN

   Loop
   Fetch p_recordset Into Contrac_rc;
   EXIT WHEN p_recordset%NOTFOUND;
       Insert into SREE_TEST(CT,DESC,FLAG)
       Values(Contrac_rc.CT,Contrac_rc.DESC,Contrac_rc.FLAG);

   End Loop;


   EXCEPTION
     WHEN NO_DATA_FOUND THEN
       NULL;
     WHEN OTHERS THEN
       -- Consider logging the error and then re-raise
       RAISE;
END PR_SREE_TEST;
/

和cs页

and cs page

  public DataSet sreetest(DataTable dt)
        {
            DataSet dsRegularIndentdtl = new DataSet();
            try
            {
                OracleConnection OraConn = new OracleConnection(strDBConnection);
                OraConn.Open();

                OracleCommand OraCmd = new OracleCommand();
                OraCmd.Connection = OraConn;
                OraCmd.CommandText = "PR_SREE_TEST";
                OraCmd.CommandType = CommandType.StoredProcedure;
                OracleParameter parameter = new OracleParameter();


                var recordSet1 = new DataTable();
                recordSet1 = dt;
               OraCmd.Parameters.Add("p_recordset", OracleDbType.RefCursor, recordSet1, ParameterDirection.Input);
                 OraCmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return dsRegularIndentdtl;
        }
    }

上面是我的代码，它说p_recordset没有valied中。请告诉我如何执行它。

above is my code it is saying that p_recordset not valied. please tell me how to execute it.

推荐答案

确保您使用的OraCmd.Parameters.Add

Make sure you are using the correct overload of OraCmd.Parameters.Add(),

按 msdn 第四个参数不是参数方向，它如下

As per msdn the fourth parameter is not parameter direction, it is as below

public OracleParameter Add(
    string parameterName,
    OracleType dataType,
    int size,
    string srcColumn
)

这篇关于如何传递datatable作为输入到C＃中的过程？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！