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

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

Postby 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
davidkennedy
 
Posts: 18
Joined: Fri 07 Jul 2006 16:21

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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?
danzman
 
Posts: 25
Joined: Wed 10 Nov 2004 16:07
Location: Orland Park, IL U.S.A.

Postby Alexey » Fri 28 Jul 2006 08:59

Sample project has been sent to your addresses. Looking forward to the feed-back.
Last edited by Alexey on Mon 31 Jul 2006 10:29, edited 1 time in total.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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.
danzman
 
Posts: 25
Joined: Wed 10 Nov 2004 16:07
Location: Orland Park, IL U.S.A.

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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.
December
Devart Team
 
Posts: 13
Joined: Thu 11 Nov 2004 08:02


Return to dotConnect for MySQL