Error: Procedure or function usp_MoveData expects param

[jwebster777]

Hi all,

I am trying to execute a stored procedure from VB.Net. I get the error: Procedure or Function usp_MoveData expects parameter @Wdate which was not supplied. My vb code is below. I am sure it is a simple fix for all you gurus.

Using my Cmd As New SqlCommand("usp_MoveData"), SqlConn)
myCmd.Parameters.AddWithValue("@WDate", dtWorshipDate.Value)
SqlConn.Open()
Try
myCmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.ToString)
EndTry
EndUsing

Thanks for any help in advance.

[thetimmer]

@WDate does not equal @Wdate

you need to match what the proc wants.
Also, please remember to use code tags when posting code

Using my Cmd As New SqlCommand("usp_MoveData"), SqlConn)
myCmd.Parameters.AddWithValue("@WDate", dtWorshipDate.Value)
SqlConn.Open()
Try
myCmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.ToString)
EndTry
EndUsing

[jwebster777]

I tried that with still the same message.

@WDate does not equal @Wdate

you need to match what the proc wants.
Also, please remember to use code tags when posting code

Using my Cmd As New SqlCommand("usp_MoveData"), SqlConn)
myCmd.Parameters.AddWithValue("@WDate", dtWorshipDate.Value)
SqlConn.Open()
Try
myCmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.ToString)
EndTry
EndUsing

[jwebster777]

I tried that with still the same message.

@WDate does not equal @Wdate

you need to match what the proc wants.
Also, please remember to use code tags when posting code

Using my Cmd As New SqlCommand("usp_MoveData"), SqlConn)
myCmd.Parameters.AddWithValue("@WDate", dtWorshipDate.Value)
SqlConn.Open()
Try
myCmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.ToString)
EndTry
EndUsing

[wild_bill]

Try adding the following before the ExecuteNonQuery call.

cmd.CommandType = System.Data.CommandType.StoredProcedure

[techgnome]

@WDate does not equal @Wdate

you need to match what the proc wants.
Also, please remember to use code tags when posting code

Using my Cmd As New SqlCommand("usp_MoveData"), SqlConn)
myCmd.Parameters.AddWithValue("@WDate", dtWorshipDate.Value)
SqlConn.Open()
Try
myCmd.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.ToString)
EndTry
EndUsing

Doesn't matter... SQL Server isn't that picky... yes, it's a good idea to match, but in the end, the case of the parameters is irrelevant. What does matter is the spelling.

Try adding the following before the ExecuteNonQuery call.

cmd.CommandType = System.Data.CommandType.StoredProcedure

That probably will do it... by default, the CommandType is text, so when you give it a table or sproc, you need to make sure you change it.

-tg