I am trying to bind a DateTimePicker to an SQL database using the "Value" property. Everything seems to work fine (i.e. appropriate values being picked up, no errors, etc.). However nothing is ever added to the database. I've checked my queries inside the query builder and everything works there fine, but it won't update from the form and I suspect it may be the DTP control. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Does anyone know how to bind a DateTimePicker?
- Thread starter artyk
- Start date
- Thread starter
- #2
Is there any other reason the form would act like it's updating the table without actually doing anything? I even call a FILL method after the update and the data remains on the form so it leads me to believe that it's being added to the TableAdapter, but not to the actual table. I have another form that is similar, although less complex, and it updates perfectly using similar code. Does anybody know anything else I could check for? Thanks!
- Thread starter
- #3
I also just checked the table relations and tried different things there thinking maybe something was getting hung up by the foreign key constraints or something. But it still didn't work. I'm seriously running out of ideas and I've searched the net to no avail, also.
- Status
Similar threads
