Re: MySqlCommandBuilder difficulties (while updating)
With a debug component, I have analyzed the DataTable which is in the DataSet.
Here's the output:
Table name: webins
Number of rows: 1
Number of columns: 20
Primary key: webinsrid
Columns:
- webinsrid, type Int32
- adres, type String
- beves, type MySqlDateTime
- cnummer, type Int32
- cursus, type String
- functie, type String
- gebdatum, type MySqlDateTime
- geslacht, type SByte
- inschr, type MySqlDateTime
- meisjenaam, type String
- meisjetuss, type String
- naam, type String
- opm, type Byte[]
- plaats, type String
- postcode, type String
- tel, type String
- tussenv, type String
- verwerkt, type MySqlDateTime
- wgnummer, type Int32
- voorlett, type String
Row state (changes only):
- Row# 0: Modified
Next command is:
RowsChanged = da.Update(ds, TableName); // always returns 0
When I use the same procedure with OleDb on a MS SQL server database, it works.
However, I would prefer to use the MySql database...
Again, what did I miss ?
Any feedback would be greatly appreciated...
The table create in MySql is:
CREATE TABLE `webins` (
`webinsrid` int(8) NOT NULL auto_increment,
`adres` varchar(40) collate utf8_bin default NULL,
`beves` date default NULL,
`cnummer` int(10) default NULL,
`cursus` varchar(100) collate utf8_bin default NULL,
`functie` varchar(100) collate utf8_bin default NULL,
`gebdatum` date default NULL,
`geslacht` tinyint(1) default NULL,
`inschr` date default NULL,
`meisjenaam` varchar(40) collate utf8_bin default NULL,
`meisjetuss` varchar(20) collate utf8_bin default NULL,
`naam` varchar(40) collate utf8_bin default NULL,
`opm` text collate utf8_bin,
`plaats` varchar(40) collate utf8_bin default NULL,
`postcode` varchar(7) collate utf8_bin default NULL,
`tel` varchar(40) collate utf8_bin default NULL,
`tussenv` varchar(20) collate utf8_bin default NULL,
`verwerkt` date default '0000-00-00',
`wgnummer` int(10) default NULL,
`voorlett` varchar(10) collate utf8_bin default NULL,
PRIMARY KEY (`webinsrid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Inschrijvingen via portal';
Kind regards,
Nico den Boer