insert query at specific field

Question

0.00/5 (No votes)

See more:

i want to insert some value at the specific field.

C#

string[] split = xx.Split(',');
                        intArray = new int[split.Length];
                        for (int i = 0; i < split.Length; i++)
                        {
                            intArray[i] = System.Convert.ToInt32(split[i]);

                        }

                        int x = 1;
                        string xxxx1 = "insert into document(bit_indicator) values("+x+") where id in(";
                        for (int k = 0; k < intArray.Length; k++)
                        {
                            xx += intArray[k] + ",";
                        }
                        xx = xx.Substring(0, xx.Length - 1) + ") and category='" + drop_cat.SelectedItem.Value + "' and subctgry='" + drop_sub_cat.SelectedItem.Value + "'";

                        SqlCommand cmd1 = new SqlCommand(xxxx1, c.getcon());
                        cmd1.ExecuteNonQuery();

it display error like: error nearer to where clause

Thanks in advance

but i want to insert value 1 at specific field so which query i will user.......

Posted 25-Apr-12 23:08pm

Mits Machhi

Updated 25-Apr-12 23:46pm

v3

Add a Solution

2 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)

Reza Ahmadi · Answer 1 · 2012-04-25T23:25:00

hi,
In order to find the error insert a breakpoint on the line with this code:

C#

SqlCommand cmd1 = new SqlCommand(xxxx1, c.getcon());

to figure at what is exactly in xxxx1, in order to help you find the problem.
Secondly, try to use string.Format to create a Sql query to make your work easier. Using

C#

string.Format

helps to reduce errors while working with strings.

I hope it helps,
Cheers

Pete O'Hanlon · Answer 2 · 2012-04-25T23:38:00

You are trying to combine a select statement and insert statement here. That's why it's complaining. While you can do this, the format needs to be very specific, e.g.

SQL

INSERT INTO MyTable(Column1)
SELECT MyColumn
FROM MyOtherTable
WHERE ID=@ID

Now, your statement doesn't look like it should be doing this type of logic - as what would be your selection criteria has no bearing on the values being put into the column.

insert query at specific field

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0