string query = "";
query = "SELECT pis, orderNo, itemNo, checker, currentDate, path FROM photo_info WHERE pis LIKE '%" + txtSearch.Text +"%'";
sql_con.Open();
try
{
DataSet ds = new DataSet();
SqlDataAdapter adt = new SqlDataAdapter(query, sql_con);
adt.Fill(ds); //fill data from sqlDataAdapter to Dataset
GridView1.DataSource = ds; //define datasource of gridview (dataset)
GridView1.DataBind(); //bind data to gridview
this.GridView1.Visible = true;