Convert NULL to empty string

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
oleengvoll
Posts: 12
Joined: Tue 27 Sep 2011 08:37

Convert NULL to empty string

Post by oleengvoll » Mon 17 Oct 2011 16:25

Hi! We are testing MySQLDataTable as datasource for a datagrid. We have a MySQL DB with a table of 30 fields. 25 of them are string field, which not accept NULL. When making a new record in this table, we start with data in only two fields. Is it possible to convert NULL to empty string so we dont have to set the 25 other fields to blank? Thanx. Ole

oleengvoll
Posts: 12
Joined: Tue 27 Sep 2011 08:37

Null value

Post by oleengvoll » Wed 19 Oct 2011 07:32

We figured this out. It is a property (a collection) in the adapter where it is possible to change DBNull to empty string.

Post Reply