CODEWITHSUNDEEP
vb.net
Manoj Singh
Manoj Singh

Reputation: 7707

How to get the value from request.querystring in vb.net

I am using VB.NET

My problem is that, I have got below request.querystring

http://localhost/ISS/Training/TrainingUpdate.aspx?cpuserid='50'&%20courseid='6'&%20status='accept'

Now I want to pass all the above three querystring in a sql stored procedure parameter.

for example,

Try
                Dim conString As String = WebConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString
                Dim con As New SqlConnection(conString)
                con.Open()
                Dim cmd As SqlCommand
                cmd = New SqlCommand("uspUpdateDelegateAcceptDeclineStatus", con)
                cmd.CommandType = CommandType.StoredProcedure
                cmd.Parameters.Add("@CPUserID", SqlDbType.Int).Value = Request.QueryString("cpuserid")
                cmd.Parameters.Add("@CourseID", SqlDbType.Int).Value = Request.QueryString("courseid")
                cmd.Parameters.Add("@StatusName", SqlDbType.Int).Value = Request.QueryString("status")
                cmd.ExecuteNonQuery()
            Catch ex As Exception
                ErrorHandler.WriteError(ex.Message)
            End Try

But I am able to get the request querystring value in my parameter.

Please suggest.

Thanks.

Best Regards, Yuv

Upvotes: 1

Views: 36762

Answers (2)

Justin Niessner
Justin Niessner

Reputation: 245419

For one, it looks like you have some extra spaces in your URL (specifically in the QueryString...marked by %20).

Not sure if that would throw things off or not, but it's a possibility.

Upvotes: 0

Joel Coehoorn
Joel Coehoorn

Reputation: 415735

Get rid of the extra '%20' (spaces) in the query string (if you can). If that's not an option, then remember that they are part of the query string, and so you'll need to include that when you access the values:

Request.QueryString(" cpuserid")

Upvotes: 2

Related Questions