Search values from database in c# sql

Use this code for searching in a gridview using textbox control




  protected void btnsearch_Click(object sender, EventArgs e)
  {
  SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DBTSSMConnectionString"].ConnectionString);
  // string str = "Data Source=.;Initial Catalog=DBTSSM;Integrated Security=True";
  //SqlConnection con = new SqlConnection(str);
  string student = txtSearch.Text == "" ? "''" : txtSearch.Text;
  string acad = txtSearch.Text == "" ? "''" :txtSearch.Text;
  string sect = txtSearch.Text == "" ? "''" : txtSearch.Text;
  string sect1 = txtSearch.Text == "" ? "''" : txtSearch.Text;
  string roll = txtSearch.Text == "" ? "''" : txtSearch.Text;
  string route = txtSearch.Text== "" ? "''" : txtSearch.Text;
  string s1 = "''";
  string query = "select *from tbl_studentss where Student_Name like '" + student + '%' + "' or Student_Acadyear like '" + acad + '%' + "' or Student_Class like '" + sect + '%' + "' or Student_Section like '" + sect1 + '%' + "' or Student_Rollno like '" + roll + '%' + "' or Route_Details like '" + route + '%' + "'";
  SqlDataAdapter da = new SqlDataAdapter(query, con);
  DataSet ds = new DataSet();
  DataTable dts = new DataTable();
  da.Fill(dts);
  insert.DataSourceID = null;
  insert.DataSource = dts;
  insert.DataBind();

  }

insert is a gridname......



mark if accepted answer...