Reputation: 0 Apprentice
- Active Members
- Active Posts:
- 88 (0.12 per day)
- 31-March 12
- Profile Views:
- Last Active:
- Sep 19 2013 11:48 PM
- Dream Kudos:
Posts I've Made
Posted 29 Sep 2012i 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
Posted 29 Sep 2012Hey 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
Posted 28 Sep 2012sorry 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
Posted 28 Sep 2012now 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
Posted 28 Sep 2012yes, 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
- Member Title:
- D.I.C Head
- Age Unknown
- Birthday Unknown