Execution of query?

Question

1.00/5 (1 vote)

See more:

SqlCommand cmd = new SqlCommand(("UPDATE [Students Records]SET "+ textBox2.Text "='" +textBox3.Text"'WHERE [Reg.No]='"+ textBox1.Text "'"), con);

This line of code gives an error:
Only assignment, call, increment, decrement, await, and new object expressions can be used as a statement.
please answer it??

Posted 19-Feb-14 5:21am

Member 10564850

Add a Solution

3 solutions

Solution 3

Try this

C#

SqlCommand cmd = new SqlCommand("UPDATE [Students Records]SET "+ textBox2.Text +  "='" + textBox3.Text + "'WHERE [Reg.No]='"+ textBox1.Text +  "'", con);

Posted 20-Feb-14 17:08pm

Karthik_Mahalingam

Solution 2

Solution 1 is good, but you need to get some extra information.

Please, see my past answer[^].

Posted 20-Feb-14 10:37am

Maciej Los

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)

Krunal Rohit · Accepted Answer · 2014-02-19T05:24:00

Solution 1

C#

SqlCommand cmd = new SqlCommand(("UPDATE [Students Records]SET "+ textBox2.Text "='" +textBox3.Text + "'WHERE [Reg.No]='"+ textBox1.Text +"'"), con);

you forgot to add '+' at the end of the statement.

-KR

Posted 19-Feb-14 5:24am

Krunal Rohit

Comments

Member 10564850 19-Feb-14 11:30am

it didn't work :(

Krunal Rohit 19-Feb-14 11:30am

now what happened ?
-KR

Member 10564850 19-Feb-14 11:33am

hogaya thanku

Krunal Rohit 19-Feb-14 21:08pm

Accept the solution, If you found your answer :)
-KR

Krunal Rohit 19-Mar-14 12:04pm

Why is is downvoted ??

-KR

Maciej Los 19-Mar-14 16:48pm

Who knows? It happens. See my answer ;)

Krunal Rohit 19-Mar-14 16:49pm

I mean seriously, sometimes I don't get it.
Even if the answer is accepted by OP, others are still downvoting it.

-KR

Maciej Los 19-Mar-14 16:57pm

I'm seriously too. You're not the only one. I'm calling it: the series law.