I would like to implement a search function where a user passes all the arguments to the "WHERE" clause at runtime. For example in query below,

SELECT Col1, Col2, Col3, Col4 
FROM MyTable 
WHERE Col2 = John

1.Now what i want is to give the user a dropdownlist of columnns such that the user selects a column to search by at runtime

1. Also instead of precoding Col2 = John, i want the user to choose their own operator at runtime(such as choosing between =, <>, <, <, LIKE, IN)

i basically want to contruct a query like

SELECT Col1, Col2, Col3, Col4 
    FROM MyTable 
    WHERE (@FieldToSearchBy e.g Col3, @OperatorToUserInSearach e.g LIKE, @ValueToSearch e.g John)

I want to pass @FieldToSearchBy, @OperatorToUserInSearach, @ValueToSearch) as user specified parameters at runtime

I want to do this with a TableAdpter like in this example http://www.codeproject.com/KB/database/TableAdapter.aspx