调用存储过程函数不工作

Question

我有这个存储过程来保存一行中的一些值。存储过程的参数是:@StepId (Int)@DateCalculationRule(字符)@Result (Int)

我的VB代码:

Private Sub buttonCalculateDatesClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles buttonCalculateDates.Click
        Dim ok As Integer = 1
        Dim connectionString As String = WebConfigurationManager.ConnectionStrings("cnnString").ConnectionString
        Dim conn As SqlConnection = New SqlConnection(connectionString)
        Dim cmd As New SqlCommand("SaveStepDeadlineRule", conn)
        cmd.CommandType = CommandType.StoredProcedure
        cmd.Parameters.Add(New SqlParameter("@StepId", 1648))
        cmd.Parameters.Add(New SqlParameter("@DateCalculationRule", "DR01#EXACTDATE"))
        cmd.Parameters.Add(New SqlParameter("@Result", 0))
        cmd.Parameters("@Result").Direction = ParameterDirection.Output
        Try
            conn.Open()
            ok = IIf(IsDBNull(cmd.Parameters("@Result").Value), 1, cmd.Parameters("@Result").Value)
        Catch ex As Exception
            ok = 1
        End Try
        conn.Close()
    End Sub

如果我使用@StepId 1648和@DateCalculationRule中的一些文本直接在数据库中运行该过程，它可以完美地工作。这是我的函数。没有任何错误

Answer 1

我错过了:cmd.ExecuteNonQuery()在conn.open()