problem in multiple query execution

Question

1.00/5 (1 vote)

See more:

i was first trying to do that execute sql query

C#

string query = "insert into ESK_Products(CateogoryID,ProductName,ProductImage,UnitCost,Description) values('" + txtproname.Text + "','" + FileUpload1.FileName + "'," + txtproprice.Text + ",'" + txtprodesc.Text + "') select CategoryID from ESK_Categories where CategoryName='" + DropDownList1.Text + "'";

but some one here tell me to split it into two queries..

C#

query1="insert into ESKProducts (categoryid) select categoryid from ESK_Categories where categoryname=dropdownlist1.Text;

query="insert into ESK_Products(ProductName,ProductImage,UnitCost,Description) values('" + txtproname.Text + "','" + FileUpload1.FileName + "'," + txtproprice.Text + ",'" + txtprodesc.Text + "')

but i am still not able to fulfil my results. what is the problem now

Posted 2-Sep-11 0:24am

codegeekalpha

Updated 2-Sep-11 0:38am

v2

Add a Solution

Comments

Oshtri Deka 2-Sep-11 6:45am

This question evolved from your other question (or vice versa).
Why don't you stick to your problem instead of asking almost the same thing two times?

3 solutions

Solution 2

Please when you ask a question about an issue explain the symptoms such as an exception message.

In the second insert you're stating 5 columns but only supplying 4 values, that is your problem.

Posted 2-Sep-11 0:30am

Simon Bang Terkildsen

Solution 3

In your first statement you have closed out the VALUES before executing the SELECT, and the values should line up on the order of the INSERT; (also, your " and ' where all out of balance......

C#

string query1 = "INSERT INTO 
                           ESK_Products(CateogoryID,ProductName,ProductImage,UnitCost,Description) 
                VALUES( 
                          (select CategoryID 
                           from ESK_Categories 
                           where CategoryName='" + DropDownList1.Text + "'),'" + txtproname.Text + "','" + FileUpload1.FileName + "','" + txtproprice.Text + "','" + txtprodesc.Text + "');

Is probably more closer to what it should be.

Posted 2-Sep-11 0:37am

DaveAuld

Updated 2-Sep-11 0:40am

v2

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)

Abhinav S · Accepted Answer · 2011-09-02T00:28:00

Solution 1

You need to provide all the columns in order to do an insert.
The first query (query1), does not contain all the column names and hence this will not execute.

Just as a note, you are not using query1 in the code you have pasted above. It could be to do with the fact that you don;t want to post all the code here.

Posted 2-Sep-11 0:28am

Abhinav S

Comments

codegeekalpha 2-Sep-11 6:37am

actually i want to post all the code here and i will do it lator.. i am in office now and left my laptop at home. because using laptop here is not allowed.

codegeekalpha 2-Sep-11 6:38am

all codes are in my laptop