asp.net beginner, getting error sql exception was unhandled by user code. plz help

Question

0.00/5 (No votes)

See more:

C#

protected void Button1_Click(object sender, EventArgs e)
    {
        if (TextBox1.Text != null)
        {
            String connectionString = "Data Source=mycomputer;Initial Catalog=master;Integrated Security=True";
            SqlConnection conn = new SqlConnection(connectionString);
            SqlCommand command = new SqlCommand("select * from listofjobs where jobs like '%'" + TextBox1.Text, conn);
            conn.Open();
            command.Connection = conn;
            SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
            GridView1.DataSource = reader;
            GridView1.DataBind();
            GridView1.Visible = true;
        }

       
       }
}

and getting the following error
{"Incorrect syntax near 'Clerk'."}
class-15
error code-2146232060
number-102
line number 1

Posted 12-Jul-12 2:52am

samip rot

Updated 12-Jul-12 3:01am

Wes Aday

v2

Add a Solution

Comments

[no name] 12-Jul-12 9:00am

You left off the other single quote at the end of your query string.

[no name] 12-Jul-12 9:02am

Actually now that I have edited your posting so that it looks decent, you need to move the second single quote to the end of your query string. "select * from listofjobs where jobs like '%" + TextBox1.Text + "'"

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)

Prasad_Kulkarni · Answer 1 · 2012-07-12T03:03:00

Solution 1

Try this:

SQL

SqlCommand command = new SqlCommand("select * from listofjobs where jobs like '%'" + "'" + TextBox1.Text + "'", conn);

Posted 12-Jul-12 3:03am

Prasad_Kulkarni

Comments

[no name] 12-Jul-12 10:12am

Too many single quotes maybe?

Manas Bhardwaj 12-Jul-12 11:20am

Correct +5!

Prasad_Kulkarni 13-Jul-12 0:02am

Thank you Manas!

Abhinav S · Answer 2 · 2012-07-12T03:07:00

Solution 2

Try

SqlCommand command = new SqlCommand("select * from listofjobs where jobs like '%" + TextBox1.Text + "'", conn);

Posted 12-Jul-12 3:07am

Abhinav S

Comments

Manas Bhardwaj 12-Jul-12 11:20am

Correct +5!

Abhinav S 12-Jul-12 12:13pm

Thanks Manas.

LittleBlackLui · Answer 3 · 2012-07-12T03:39:00

You can do somthing like this too:

C#

string job = TextBox1.Text;
string query = String.Format("select * from listofjobs where jobs like '%{0}'", job);
SqlCommand command = new SqlCommand(query, conn);

Where the value in variable "job"is assigned to the index {0} in the string "query".

But Prasad_Kulkarni answer your question, mine is just a sugestion.

asp.net beginner, getting error sql exception was unhandled by user code. plz help

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us