Search from DB with LIKE Operator

Mohit Kapoor

I am getting an incorrect syntax error on following code .

There's an error in Sql query ?

protected void btnByName_Click(object sender, EventArgs e)

        {
            string name = txtByName.Text.Trim();

            Response.Write("clicked \n");
            cmd.Connection = con;

            cmd.CommandText = "select * from books where name LIKE '%' "+name+" '%' ";

            con.Open();
            rdr=cmd.ExecuteReader();

if(rdr.Read())

            {
               Response.Write(" found
");
                    GridView1.DataSource = rdr;
                    GridView1.DataBind();
            }
            else
                Response.Write("no match found");
             con.Close();



        }

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Munesh Sharma10y ago
cmd.CommandText = "select * from books where name like '%" + Name+ "%'";
0
ketan borsdiya10y ago
Hi Mohit,
If your name contain apostrophe(') then use below code
string name = "Ketan's";
name = name.Replace("'", "''");
cmd.CommandText = "select * from books where name LIKE '%"+name+"%'";

Otherwise you just replace your string with below one,
cmd.CommandText ="select * from books where name LIKE '%"+name+"%'";
0
Bikesh Srivastava10y ago
Hi,
try this..
SELECT*FROMbooks
WHEREnameLIKE's%';
0
Midhun Tp10y ago
Hi please try like this -
cmd.CommandText = "select * from books where name LIKE '%"+name+"%' ";
0