If I include a column in my dataset that I have defined as a datetime data type, I eventually get concurrency errors from the datagridview.
The dataset includes as I mentioned a datetime data type.
The grid is bound via the usual tableadapter and bindingsource.
The grid allows deletes. When the delete occurs, I try to update the database in the rowdeleted event. Calling the normal tableadapter.update(dataset.table) causes a concurrency error.In looking at the data both original and modified via the dataset, it looks identical.
This particular application is only used in a single user environment. The error does not occur if the datetime column is not included in the dataset.
Can anyone recommend a solution? Should I be modifying the date value in some way. Should I abandon the datetime datatype in leui of a text datatype since SQLite doesn't really support a datetime data type? Any recommendation are appreciated.