Hello to all

I am working with vb.net.
I am having table contains all information of customer
like first name, last name, address, contatc numbers etc.(35 fields)

I want to search record from database acording to
any field as user of my application needs.

I generate querries by using if..else.. but it is
vary difficult and can not be used for more than one
table.

Is there any control awailable (vb controls or third party controls)that can generate querries for
me or any program logic that servers me ?

Thank you.

Once you have your data in a dataset, you could iterate thru each column and generate a search string for the datatable's default view "filter" property. You can get the datafield from the column and construct a filter string similar to SQL:

fieldname like '%search value%'

Do this for each column, and string them together with commas, then assign to the datatable's defaultview.filter property. Then the default view will have your filtered data. You can do it all on the .net object side instead of the database side.