[MySQLDirect . net data provider] can't generate update command
[MySQLDirect . net data provider] can't generate update command
Hello ,
first I've tried to install MySQLDirect .NET but it dosn'et work so i've installed unidirect and it works but I can generate update command and delete command....
I'm using VS 2005 + framework 2 and Mysql 4.1.12
Can somebody help me please ?
thanks
first I've tried to install MySQLDirect .NET but it dosn'et work so i've installed unidirect and it works but I can generate update command and delete command....
I'm using VS 2005 + framework 2 and Mysql 4.1.12
Can somebody help me please ?
thanks
Ok ,
I've installed UniDirect .NET version 2.00 for .NET Framework 2.0 on my XP pro + VS 2005
- i've added unidirect elements on toolbox windows
- created new connection on server explorer to my mysql server
- created a dataset with a datatable from my mysql server
- generated SELECT and INSERT command but UPDATE and DELETE can't be created ....
I've installed UniDirect .NET version 2.00 for .NET Framework 2.0 on my XP pro + VS 2005
- i've added unidirect elements on toolbox windows
- created new connection on server explorer to my mysql server
- created a dataset with a datatable from my mysql server
- generated SELECT and INSERT command but UPDATE and DELETE can't be created ....
UniDirect .NET version 2.00 for .NET Framework 2.0 (Trial Version for the moment)
CREATE TABLE `ClientsContacts` (
`indice` int(10) NOT NULL auto_increment,
`societeContact` varchar(250) default NULL,
`civiliteContact` varchar(250) default NULL,
`nomContact` varchar(250) default NULL,
`prenomContact` varchar(250) default NULL,
`fonctionContact` varchar(250) default NULL,
`adresseContact` varchar(250) default NULL,
`adresse2Contact` varchar(250) default NULL,
`cpContact` varchar(20) default NULL,
`villeContact` varchar(250) default NULL,
`Pays` varchar(50) default 'France',
`telContact` varchar(250) default NULL,
`telMobile` varchar(20) default NULL,
`faxContact` varchar(20) default NULL,
`mailContact` varchar(250) default NULL,
`provenance` varchar(250) default NULL,
`Commentaire` text,
`ctrEmailing` tinyint(1) unsigned default '0',
`ctrHebergement` tinyint(1) unsigned default '0',
`ctrInternet` tinyint(1) unsigned default '0',
`ctrSecurite` tinyint(1) unsigned default '0',
`ctrDevSoft` tinyint(1) unsigned default '0',
`ctrTeleMF` tinyint(1) unsigned default '0',
`ctrRoutage` tinyint(1) unsigned default '0',
`ctrBackup` tinyint(1) unsigned default '0',
`ctrCVL` tinyint(1) unsigned default '0',
`dateCreation` date default NULL,
PRIMARY KEY (`indice`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;