[MySQLDirect . net data provider] can't generate update command

RideKick · Post by **RideKick** » Wed 27 Dec 2006 10:09

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

Alexey · Post by **Alexey** » Wed 27 Dec 2006 10:21

Please describe the problem in detail. What is meant by "MySQLDirect .NET doesn't work"?

RideKick · Post by **RideKick** » Wed 27 Dec 2006 10:27

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 ....

Alexey · Post by **Alexey** » Wed 27 Dec 2006 11:09

OK, i see. We are investigating this problem.
You will be notified on results as soon as possible.

RideKick · Post by **RideKick** » Wed 27 Dec 2006 11:10

thanks

Alexey · Post by **Alexey** » Wed 27 Dec 2006 11:11

To create update commands use our DataSet wizard from the Tools menu.

RideKick · Post by **RideKick** » Wed 27 Dec 2006 12:14

ok , but i want dataAdapter generated commands which are automatically built by the wizard

Alexey · Post by **Alexey** » Wed 27 Dec 2006 12:21

You'll get them using our wizard as well.

RideKick · Post by **RideKick** » Wed 27 Dec 2006 12:26

It doesn't work , I have to complete Update query manually , only SELECT and INSERT are automatically completed

Alexey · Post by **Alexey** » Wed 27 Dec 2006 12:32

What is the full version of UniDirect .NET you use? Professional or Standard edition?
Please provide your table definition.

RideKick · Post by **RideKick** » Wed 27 Dec 2006 12:46

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;

Alexey · Post by **Alexey** » Wed 27 Dec 2006 13:00

I've just checked this. All the commands are generated with default options of Dataset wizard. Please describe the steps you perform to create your dataset.

RideKick · Post by **RideKick** » Wed 27 Dec 2006 15:15

in solution's explorer window

- RightClic on projet -> add new element
- Dataset

to add datatable :

In server explorer window

- drag/drop datatble from mysql connexion

RideKick · Post by **RideKick** » Wed 27 Dec 2006 15:50

Ok , I've found the solution with the unidirect dataset wizard....thanks for your help !

Alexey · Post by **Alexey** » Thu 28 Dec 2006 07:18

Right. From the Tools menu as I mentioned before.