Procedure or function expects parameter which was not supplied.

Question

1.00/5 (1 vote)

See more:

HI Everyone this is my continuation to my problem lately and I come up with my program with this:

VB.net

VB

Protected Sub UploadBtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles UploadBtn.Click

   Dim conn As New SqlConnection("Data Source=192.168.0.4;Initial Catalog=CYBERYA;Persist Security Info=True;User ID=cyberya;Password=Piso4minutes;MultipleActiveResultSets=True")

        ' set up call for stored procedure

        Dim cmdtest As New SqlCommand("Populatecsv", conn)
        cmdtest.CommandType = CommandType.StoredProcedure
        ' parameter settings
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@status", "status"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@CustomerName", "customername"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@HomeContact", "homecontact"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@BusinessContact", "businesscontact"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@MobileContact", "mobilecontact"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@LotHouseNo", "lothouseno"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@RoomUnitStall", "roomunitstall"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@BldgFloor", "bldgfloor"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@BldgName", "bldgname"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@Street", "street"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@Subdivision", "subdivision"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@Barangay", "barangay"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@CityMunicipality", "citymunicipality"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@Province", "province"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@Region", "region"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@Package", "package"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@PromoCode", "promocode"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@ApplicationDate", "applicationdate"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@EndorsedDate", "endorseddate"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@paymenttype", "paymenttype"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@scheduledate", "scheduledate"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@loanstatus", "loanstatus"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@ActivationDate", "activationdate"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@pcdelivery", "pcdelivery"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@nopcavailed", "nopcavailed"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@datepcpickup", "datepcpickup"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@pcissuance", "pcissuance"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@salesagent", "salesagent"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@Coordinator", "Coordinator"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@SalesChannel", "saleschannel"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@SalesGroup", "salesgroup"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@CreatedBy", "CreatedBy"))
        cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@timestamp", "timestamp"))
        ' end call params


        conn.Open()
        cmdtest.Connection = conn
        cmdtest.ExecuteNonQuery()
        conn.Close()

End Sub
End Class

then im come up with this error: "Procedure or function 'Populatecsv' expects parameter '@SRN', which was not supplied." in this line

VB

Line 320:        conn.Open()
Line 321:        cmdtest.Connection = conn
Line 322:        cmdtest.ExecuteNonQuery()
Line 323:        conn.Close()
Line 324:        ''Dim myconnect As New SqlClient.SqlConnection

im wondering whats the problem of my command where in i already stated the data source please help me guys..

very well appreciated :)

Posted 3-Jun-13 4:14am

Member 10033107

Updated 3-Jun-13 15:09pm

Chris Maunder773.6K

v3

Add a Solution

Comments

Mike Meinz 3-Jun-13 10:20am

You have not supplied the parameter @SRN

cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@SRN", --value--))

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Balimusi · Answer 1 · 2013-06-03T04:25:00

Solution 1

You seems to have the @SRN parameter in your "Populatecsv" stored procedure. You need to either remove it from the stored procedure or include that parameter (@SRN) in your VB.NET code.

Posted 3-Jun-13 4:25am

Balimusi

Member 10033107 · Answer 2 · 2013-06-03T14:35:00

Solution 2

Thanks Balimusi and mike for the replys..

I already added cmdtest.Parameters.Add(New Data.SqlClient.SqlParameter("@SRN", --value--)) yet an error shows this message:

SQL

Error converting data type nvarchar to bigint.

in this section so what it does means??

Line 321: conn.Open()
Line 322: cmdtest.Connection = conn
Line 323: cmdtest.ExecuteNonQuery()
Line 324: conn.Close()
Line 325: ''Dim myconnect As New SqlClient.SqlConnection

Posted 3-Jun-13 14:35pm

Member 10033107

Updated 3-Jun-13 14:40pm

v2

Comments

[no name] 3-Jun-13 21:17pm

It means exactly what is says. It cannot convert the string --value-- to a bigint datatype.

Member 10033107 3-Jun-13 21:23pm

yes but how? i didnt get it because i set my stored procedure as bigint and why so sudden it has an error such as this i might still checking it out maybe you know or explain how it will be solved?

Member 10033107 · Answer 3 · 2013-06-03T16:00:00

Solution 3

Ive just added this command

VB

Dim param = New System.Data.SqlClient.SqlParameter()
      param.ParameterName = "@srn"
      param.Direction = ParameterDirection.Output
      param.Size = 10
      cmdtest.Parameters.Add(param)

yet ive still got the same error with regards to this Error converting data type nvarchar to bigint... Help guys.. >.<</xml>

Posted 3-Jun-13 16:00pm

Member 10033107

Comments

Mike Meinz 12-Jun-13 6:15am

It is considered bad manners to enter a Solution to your own question that should really be entered as a clarifying "Have a question or comment" or through "Improve Question".

That said, your parameter has to match the data type that is declared in the Stored Procedure:


        Dim param As New System.Data.SqlClient.SqlParameter
        param.ParameterName = "@srn"
        param.Direction = ParameterDirection.Output
        param.SqlDbType = SqlDbType.BigInt