Help in inserting quotes in database

Question

hi, can anybody please tell me how do i insert a string which has quotes in it string. i know that we have to use double quotes before the apostrophe, but the problem is i have to insert 100 rows , each having 80 columns and the the apostrophe can occur in any of these 80 columns. . so shld i check for each column, whether it has a 'quote or not' for each row . please help thanx in advance

Answer 1

I found my own solution... I found that I could not have a DateTimePicker control bound to the dataset. When the DateTimePicker control was bound to the dataaset, the data would not display in any of the controls on the form. When I "un-bound" the DateTimePicker control, then the data woudl display properly. I bound an edit box to the date column and then updated the DateTimePicker control when the value of the edit box changed.