Can I hire someone or get some help in understanding how to use SQLDirect?

davidkennedy · Post by **davidkennedy** » Thu 27 Jul 2006 13:24

I'm sure this is a wonderful product and I've looked at the online help files for hours, but can't seem to see the 'forest through the trees'. In the next few years I'm going to have to create many 3 tiered ASP systems that intimately deal with MySQL databases. I'm happy to spend the money if I could find someone that could do a little 'mentoring'. I live in Texas and thought a few phone calls might get me going. I've read every ASP.NET 2.0 book I can find from Amazon.com and have followed them through page by page, so hopefully I have a good enough background that we might communicate. Thank you for your consideration.
David 775-885-9125

Alexey · Post by **Alexey** » Thu 27 Jul 2006 13:48

If you be a bit more specific I hope we might get you going even without any phone calls.

danzman · Post by **danzman** » Fri 28 Jul 2006 01:05

I think I know what David wants. Like myself, I had to experiment with a lot of approaches in order to get thru phase I. I would think that David wants to do the following:

1. Setting up the connection to the database.
2. Accessing the data.
3. Displaying the data or record(s).
4. Adding new record.
5. Editing a record.
6. Deleting a record.

If you have a sample web application that does the above that should be sufficient enough to give people a good start. Of course, like a grade school teacher the tutorial must be presented in a step-by-step fashion and with good explanation along the way. Don't you think so?

Alexey · Post by **Alexey** » Fri 28 Jul 2006 08:59

Sample project has been sent to your addresses. Looking forward to the feed-back.

danzman · Post by **danzman** » Fri 28 Jul 2006 13:22

Thanks, Alexey. I am having problems creating the database. the testdb.sql has issues with MySQL version 4.0.17. Using PHPMyAdmin, I created the 'testdb' database, uploaded the 'testdb.sql' and ran. It showed errors with delimiters and the engine statement.

Alexey · Post by **Alexey** » Mon 31 Jul 2006 06:57

MySQL server version 4.0.17 doesn't support stored procedures. So i adjusted the sample project and re-sent it to you. You only need to create one table and populate it with data using the script below:

Code: Select all

CREATE TABLE testdb.customers (
  `CUST_ID` int(10) unsigned NOT NULL auto_increment,
  `CUST_FIRSTNAME` varchar(45) NOT NULL default '',
  `CUST_LASTNAME` varchar(45) NOT NULL default '',
  `CUST_LAST_UPDATE_DATE` datetime NOT NULL default '0000-00-00 00:00:00',
  `CUST_ADDRESS` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`CUST_ID`)
) Type=InnoDB;

INSERT INTO testdb.customers VALUES (1,'TAI MAN','CHAN','2006-04-24 00:00:00',''),(2,'Lee','Billsss','2006-04-25 11:03:57',' '),(7,'test','test','2006-04-25 15:03:03',''),(8,'a','bb','0000-00-00 00:00:00',''),(9,'b','cd','0000-00-00 00:00:00',''),(10,'ab','cdede','0001-01-01 00:00:00','x'),(11,'abc','cde','2006-04-25 17:26:47','');

Don't forget to change connection string.

December · Post by **December** » Mon 31 Jul 2006 09:55

I'd like to state that currently we are preparing set of tutorials that will guide developers step-by-step through common database operations and advanced MySQLDirect .NET features. The tutorials will probably be available in the next version of the Data Provider.