Question

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.

Closed 11 years ago.

我怎么能从结构分类的计算中得到结果?

有两个案件”

CASE 1
 RETURN "Process ok"
CASE 2
 RETURN "Process failed"

This will be returned from the stored procedure.

怎样才能在www.net、C#(Windows Forms)上阅读?

Answer 1

如果您认为可以取得多个记录或<代码>,请您使用<代码>DataReader。缩略语如果你只获得单一价值,没有记录,没有多个栏目,只是一个插头或暗中......

在这里,如何使用储存程序,然后让读者阅读第1栏:

using(var  conn = new OracleConnection("Data Source=oracledb;User Id=UserID;Password=Password;"))
{
    OracleCommand cmd = new OracleCommand();
    cmd.Connection = conn;
    cmd.CommandText = "storedProcedurename";
    cmd.CommandType = CommandType.StoredProcedure;

    cmd.Parameters.Add(...);

    conn.Open();
    OracleDataReader dr = cmd.ExecuteReader();

    while(dr.Read())
    {
        var yourResult = dr[0].ToString();
    }
}

Answer 2

这取决于你是否正在援引所储存的程序,或者如果你试图收回记录。

关于所储存的程序,它可以将数值分配到<代码>>out <>>>或inout参数或生成一个记录。前者需要使用command.CommandType至。

典型的问题是:

using (var cmd = connection.CreateCommand())
{
    cmd.CommandText = "SELECT something FROM YourTable";
    using (var reader = cmd.ExecuteReader())
    {
        while (reader.Read())
        {
            Console.WriteLine(reader["something"]);
        }
    }

}

关于数据库链接,我确实建议你使用

友情链接