query string split values

Question

0.00/5 (No votes)

See more:

my query string is....\mypage.asp?q="Name=Ram|Email=ram@yahoo.com|Mobile=123456789|Address=sdfsg"
here i want to split it.As like- Name=Ram,Email=ram@yahoo.com...etc,and here,I want to insert this values in database field like Name,Email...etc.Here also query string may be varied.Please tell me
solution ,here i want to insert values in pageload event of .asp page not .aspx page.

please give me insertion code for insert value in sql server database.from .asp page.

Posted 9-Sep-11 6:30am

rajendra@patil55

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)

Wendelius · Answer 1 · 2011-09-09T06:39:00

You can use String.Split[^] to split the input based on the delimiter. This will give a string array where you will find the idividual elements.

However, if the amount pf fields may vary in your input string, how are you going to know which field is which?

Anyhow, after you have splitted the string, you can build up a SqlCommand[^], define SqlParameters[^] and the use the ExecuteNonQuery method to insert the data into the database.

The insert statement would look something like:

SQL

INSERT INTO TableNamw (Name, Email, ...)
VALUES (@name, @email, ...)

where @... will be the parameters where you define the values to insert from the string array.

To define the parameters and the values you can use SqlParameterCollection.AddWithValue[^] method

hitech_s · Answer 2 · 2011-09-09T19:19:00

Solution 2

i dont know exactly but i think it helps you

first get the query string value
then use string.split('|')
like
string [] variable=yourquerystring.split('|');

Posted 9-Sep-11 19:19pm

hitech_s

Yogesh Pednekar · Answer 3 · 2011-09-09T20:08:00

Solution 3

use this.

"Inventory Reports/CRSalesInvoice.aspx?" + "&Name=" + "Ram" + "&Email=" + "ram@yahoo.com"

and access name and email query string on another form as follow.

string Name;
Name = Request.QueryString["Name"];
string Email;
Email = Request.QueryString["Email"];

Yogesh Pednekar.

Posted 9-Sep-11 20:08pm

Yogesh Pednekar