Hi Maverick,
You can do one thing
string query="select * from tblResults ";
string sql=string.Empty;
if(!txta.equals(""))
sql+="where column1 like '% " + txta.text + "%' ";
if(!txtb.equals(""))
if(sql.equals(""))
sql+="where column2 like '% " + txtb.text + "%' ";
else
sql+="and column2 like '% " + txtb.text + "%' ";
if(!txtc.equals(""))
if(sql.equals(""))
sql+="where column3 like '% " + txtc.text + "%' ";
else
sql+="and column3 like '% " + txtc.text + "%' ";
if(!txtd.equals(""))
if(sql.equals(""))
sql+="where column4 like '% " + txtd.text + "%' ";
else
sql+="and columnd like '% " + txtd.text + "%' ";
query +=sql;
Then run the query in "query" variable
Please make it resolved if it resolves your issue
Thanks and Regards
Suman Zalodiya