Please Help! ParameterValues As List(Of SqlParameter)

Question

3.50/5 (2 votes)

See more:

Hi All,
I use the function below. Using this code:

VB

Dim Parameters(0 To 1) As SqlParameter
Parameters(0) = New SqlParameter("@username";, txtUsername.Text)
Parameters(1) = New SqlParameter"@ret", ret)
ret =clsDataAccess.NonQuery("usp_checkLogin",Parameters,
CommandType.StoredProcedure)

I got an error in the second parameter (Parameters) in the function (ByVal ParameterValues As List(Of SqlParameter)... the error is ....
Value of type '1-dimensional array of System.Data.SqlClient.SqlParameter' cannot be converted to 'System.Collections.Generic.List(Of System.Data.SqlClient.SqlParameter)'.

What's missing in my code?

Here is the function:

VB

Public Shared Function NonQuery(ByVal CommandText As String, _
           ByVal ParameterValues As List(Of SqlParameter), _
           ByVal CommandType As CommandType) As Integer
        Dim res As Integer = 0
        Dim Parameter As SqlParameter
        Dim SqlConn As SqlConnection = Connection
        Try
            SqlConn.Open()
            SqlComm = New SqlCommand(CommandText, SqlConn)
            SqlComm.CommandTimeout = 600
            SqlComm.CommandType = CommandType
            If (ParameterValues IsNot Nothing) Then
                For Each Parameter In ParameterValues
                    SqlComm.Parameters.Add(Parameter)
                Next
            End If
            res = SqlComm.ExecuteNonQuery()
        Catch ex As Exception
            Throw ex
        Finally
            SqlConn.Close()
        End Try
        Return res
    End Function</pre>

Again, please help me..

Thanks so much in advance!
Regards,

Posted 7-Feb-11 23:28pm

obrix_activex

Updated 7-Feb-11 23:30pm

Sandeep Mewara

v2

Add a Solution

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)

Simon_Whale · Answer 1 · 2011-02-08T01:05:00

Solution 1

You need to convert your arraylist into a generic list. Have a read of the below that should point you in the right direction

Converting an arraylist into a generic list[^]

Posted 8-Feb-11 1:05am

Simon_Whale

Dwayne J. Baldwin · Answer 2 · 2011-02-08T01:24:00

You are trying to pass an array to a function signature expecting a list.

SqlParmameter(0 to 1) is not the same as List(Of Sql Parameter).

Quick Fix: Change it to a list

"usp_checkLogin",Parameters.ToList,CommandType.StoredProcedure)

Better Fix: Use a list in the first place

Dim Parameters As New List(Of SqlParameter)
Parameters.Add(New SqlParameter("@username", txtUsername.Text))
Parameters.Add(New SqlParameter("@ret", ret))

#realJSOP · Answer 3 · 2011-02-08T01:31:00

Solution 3

You're missing the left parenthesis. Yours is this:

VB

Parameters(1) = New SqlParameter"@ret", ret)

It should be this:

VB

Parameters(1) = New SqlParameter("@ret", ret)

Posted 8-Feb-11 1:31am

#realJSOP