SqlParameterCollection只接受非null的SqlParameter类型对象。 [英] The SqlParameterCollection only accepts non-null SqlParameter type objects.
问题描述
     
嗨专家,
Hi Expert,
需要帮助,下面是我的代码和第200行显示的错误是
Need help in your end, below is my code and the error shown in line 200 which is
- commands.Parameters.AddRange(params)。我该如何解决?
Private Sub Button1_Click( sender As Object,e As EventArgs)Handles Button1.Click
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
      Dim params(9)As SqlParameter
      params(0)= New SqlParameter(" @ WSTransactions",SqlDbType.Char)
      params(0).Value = TextBox1.Text
      params(1)= New SqlParameter(" @ ItemNo",SqlDbType.Char)
      params(1).Value = ComboBox2.Text
      params(2)= New SqlParameter(" @ Description",SqlDbType.VarChar)
      params(2).Value = ComboBox3.Text
      params(3)= New SqlParameter(" @ Requestor",SqlDbType.Char)
      params(3).Value = ComboBox1.Text
      params(4)= New SqlParameter(" @QtyRequested",SqlDbType.Int)
      params(4).Value = TextBox3.Text
      params(5)= New SqlParameter(" @ DateRequested",SqlDbType.DateTime)
      params(5).Value = DateTimePicker1.Text
      params(6)= New SqlParameter(" @ DateNeeded",SqlDbType.DateTime)
      params(6).Value = DateTimePicker2.Text
      params(7)= New SqlParameter(" @ DaysAlloted",SqlDbType.Int)
      params(7).Value = Label6.Text
      params(8)= New SqlParameter(" @Remarks",SqlDbType.VarChar)
      params(8).Value = TextBox4.Text
      Dim命令As New SqlCommand
      commands.Connection = connection
      commands.CommandType = CommandType.StoredProcedure
      commands.CommandText =" EXEC spWSLIPTRANSACTIONS"
      commands.Parameters.AddRange(params)
      connection.Open()
      commands.ExecuteNonQuery()
      connection.Close()
Dim params(9) As SqlParameter
params(0) = New SqlParameter("@WSTransactions", SqlDbType.Char)
params(0).Value = TextBox1.Text
params(1) = New SqlParameter("@ItemNo", SqlDbType.Char)
params(1).Value = ComboBox2.Text
params(2) = New SqlParameter("@Description", SqlDbType.VarChar)
params(2).Value = ComboBox3.Text
params(3) = New SqlParameter("@Requestor", SqlDbType.Char)
params(3).Value = ComboBox1.Text
params(4) = New SqlParameter("@QtyRequested", SqlDbType.Int)
params(4).Value = TextBox3.Text
params(5) = New SqlParameter("@DateRequested", SqlDbType.DateTime)
params(5).Value = DateTimePicker1.Text
params(6) = New SqlParameter("@DateNeeded", SqlDbType.DateTime)
params(6).Value = DateTimePicker2.Text
params(7) = New SqlParameter("@DaysAlloted", SqlDbType.Int)
params(7).Value = Label6.Text
params(8) = New SqlParameter("@Remarks", SqlDbType.VarChar)
params(8).Value = TextBox4.Text
Dim commands As New SqlCommand
commands.Connection = connection
commands.CommandType = CommandType.StoredProcedure
commands.CommandText = " EXEC spWSLIPTRANSACTIONS"
commands.Parameters.AddRange(params)
connection.Open()
commands.ExecuteNonQuery()
connection.Close()
End Sub
推荐答案
尝试此修改:
Dim params(8)As SqlParameter
Dim params(8) As SqlParameter
这篇关于SqlParameterCollection只接受非null的SqlParameter类型对象。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!