How to pass integer parameter to query string

Question

0.00/5 (No votes)

See more:

I need to pass int data to Id when I redirect to the page but the id is being read as string when I put it between " " and I tired the code below but I got error conversion failed when converting the varchar value to data type int

when I did it in asp.net tag it works fine

What I have tried:

Response.Redirect("View.aspx?Id="+ HttpContext.Current.Request.QueryString["MaId"].ToString());

and this also not working
Response.Redirect("View.aspx?Id="+ Eval("MaId") );

Posted 28-Jul-16 4:51am

Member 12618369

Updated 28-Jul-16 4:53am

Add a Solution

1 solution

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)

F-ES Sitecore · Accepted Answer · 2016-07-28T04:53:00

Solution 1

You have to pass it as a string, querystring params are always string. Your View.aspx page needs to convert it back to an int

C#

int id = 0;
int.TryParse(Request.QueryString["id"], out id);

Posted 28-Jul-16 4:53am

F-ES Sitecore

Comments

Member 12618369 28-Jul-16 11:01am

Thanks
please clarify more where I have to put this code in view page or the page where I write direct response
please

F-ES Sitecore 28-Jul-16 11:03am

That code will go on the View.aspx page.

Member 12618369 28-Jul-16 11:17am

thanks
I tried to used but not working I think because MaId is int and it is passed by id with int it works from another page I need to ckeck is the id is string or int if it is string I need to convert it before I passed to MaId
I am sorry about that
please help
cmd.CommandText = "SELECT URLVideoPath FROM Material WHERE MaId=@MaId";
// int.TryParse(Request.QueryString["id"], out id);
cmd.Parameters.AddWithValue("@MaId", id);
cmd.Connection = con;
con.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{

sdr.Read();
URL = sdr["URLVideoPath"].ToString();

F-ES Sitecore 28-Jul-16 11:20am

You'll do the int.TryParse here

int id = 0;
int.TryParse(Request.QueryString["id"], out id);
cmd.Parameters.AddWithValue("@MaId", id);

Member 12618369 28-Jul-16 11:27am

Thanks
I got error red line under the id said id cannot be declared in this scope because that name is used in an enclosing local scope to define a local or parameter
I do not know what is it
please help

F-ES Sitecore 28-Jul-16 11:30am

Then you'll have defined "id" earlier on the page. If this id variable is intended for this querystring data then simply drop the declaration and leave your original in place

int.TryParse(Request.QueryString["id"], out id);
cmd.Parameters.AddWithValue("@MaId", id);