string sql = "select F_Code,F_Name,CategoryFood_Tb.CF_CategoryFood,F_Price,F_image From (Food_Tb inner join CategoryFood_Tb on Food_Tb.[CF_Type]=CategoryFood_Tb.[CF_Type]) WHERE F_Code LIKE '" + txt_Fsearch.Text + "%' OR F_Name LIKE '" + txt_Fsearch.Text + "%'";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);