How to insert data in a table from two different forms ? using id stored in session asp.net

Question

0.00/5 (No votes)

See more:

Query to insert data in a table from two different forms ? using id stored in session
i mean can we use like .... insert into table1() values () where userid=session[userid] ??

Posted 9-Apr-14 22:33pm

jayraj86

Add a Solution

Comments

Bh@gyesh 10-Apr-14 4:56am

Hi,
can you please more elaborate with your question?
One thing you can do, you can save one form value in session or pass with querystring to another form. then on final form you can insert records in two tables.

3 solutions

Solution 1

OP Wrote:
can we use like .... insert into table1() values () where userid=session[userid]

No.You cannot use like that. Insert statement have no where clause

Posted 9-Apr-14 23:02pm

Tom Marvolo Riddle

Comments

Nirav Prabtani 10-Apr-14 5:05am

sorry by mistake i've voted +1
now how can i upvote it???

Tom Marvolo Riddle 10-Apr-14 5:06am

yup press ctrl+ f5 and you can revote it

Nirav Prabtani 10-Apr-14 5:17am

I have done it.... :)

Tom Marvolo Riddle 10-Apr-14 5:18am

Thank you Nirav Prabtani

Solution 3

The INSERT INTO statement is used to insert new records in a table, there is no need for WHERE clause. Refer: Using-Parameterized-queries-to-prevent-SQL-Injection-Attacks-in-SQL-Server.aspx[^]
An example:

strQuery = "insert into tablename(userID, userName)values(@userID, @userName)";
cmd = new SqlCommand(strQuery);
cmd.Parameters.AddWithValue("@userID", Session["userid"]);

Posted 9-Apr-14 23:11pm

Peter Leow

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)

**Nirav Prabtani** · Accepted Answer · 2014-04-09T23:07:00

Solution 2

No you can not user where clause whith insert statement ,
If you have to set data to perticuler ID then you can use
Update sql query like this.... :) :)

SQL

UPDATE Table Set ColumnName=@ColumnData,ColumnName=@ColumnData2.... where userid=Session[userid]

Posted 9-Apr-14 23:07pm

Nirav Prabtani

Comments

jayraj86 10-Apr-14 9:29am

Thanks a lot. I never thought about that :)

jayraj86 10-Apr-14 9:33am

one other problem i m stuck at right now, can you sort it out ?
here is the link http://www.codeproject.com/Questions/756411/In-Asp-Net-Csharp-I-Have-Four-Dropdownlist-And-I-W