Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Search from DB with LIKE Operator
Mohit Kapoor
Aug 28 2016 4:46 PM
275
Reply
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 <br>");
GridView1.DataSource = rdr;
GridView1.DataBind();
}
else
Response.Write("no match found");
con.Close();
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Selected District not retrieved for employee in edit view ge
Dropdownlist getting full postback inside update panel