OP wrote:
I'm facing problem while running query i write the following code but it is not working well.
What do you mean? any error message?
Try like these
OleDbDataAdapter da = new OleDbDataAdapter("Select p_name,id_no,rout,d_o_b from passager where p_name like'" + s + "%'", con);
or
OleDbDataAdapter da = new OleDbDataAdapter("Select p_name,id_no,rout,d_o_b from passager where p_name like'" + textBox1.Text + "%'", con);