i tried building the string using like not = and it worked it didnt throw any exception what do you think ? is it good to use?
by the way getting the valuetype is amazing i loved it it can be used in so many things

Hey Thank you, yes i can see why you dont want the column of product ID it will throw an exception coz it is an int but the datetime also throws the same conversion.
maybe i should only restrict the search to bookName or booktype only and not let them search for anything in the sql.

coz i dont think it will work this way though so many programs you can throw any search and it will give you results but as you said ( maybe when you do use a search they have specific fields you search in and thus they know the datatypes and make the query to fit them)

so what you think please advise.
and thank you again really

sorry i cant open my eyes anymore its 1:25 am sleepy i will check your post later today and see what can i do and again thank you so much for you efforts and hope we can get it to work

Thank you again

now i got what you mean yes you are right on the first next the dt changes so it willl search in an empty dt or in a result dt Mmmm but i dont know how to fix it

yes, when i press view table the dgv is DataGridView1.DataSource = dt so i see the table on datagridview then when i build my string ( search in sql ) lets say find word try i put the result on another dt which is dt3 thats all