MySQL 5 C# sample code using ObjectDataSources

1) You must have MySQL 5 up and running

2) You must install "MySQL Connector/Net 1.0" from: http://dev.mysql.com/downloads/connector/net/1.0.html

3) Create a MySQL 5 database named "Test"

4)  Create a table in that database called Message:

CREATE TABLE test.message (
Entry_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
Name VARCHAR(45),
Email VARCHAR(45),
Message VARCHAR(200),
PRIMARY KEY (Entry_ID)
)
AUTO_INCREMENT=32
CHARACTER SET latin1 COLLATE latin1_swedish_ci;

5) Create these MySQL stored procedures:

PROCEDURE `test`.`DeleteMessage`(IN param1 INT)
BEGIN
Delete From test.message
WHERE Entry_ID = param1;
END
PROCEDURE `test`.`InsertMessage`(IN param1 VARCHAR(50), IN param2 VARCHAR(50), IN param3 VARCHAR(200))
BEGIN
INSERT INTO message(Name, Email, Message)
VALUES(param1,param2,param3);
END
PROCEDURE `test`.`ShowAll`()
BEGIN
SELECT 
� message.Entry_ID, 
� message.Name, 
� message.Email, 
� message.Message
FROM
� test.message;
END
PROCEDURE `test`.`UpdateMessage`(IN paramkey INT, IN param1 VARCHAR(50), IN param2 VARCHAR(50), IN param3 VARCHAR(200))
BEGIN
UPDATE��� message
SET������������� Name = param1, Email = param2, Message = param3
WHERE���� (message.Entry_ID = paramkey);
END

6) Unzip the "MySQL" and configure IIS to point to it. MAKE SURE YOU CONFIGURE THE WEBSERVER TO USE ASP.NET 2.0

7) Open "web.config" and change the line:
		<add name="MySQLConnectionString" connectionString="server=localhost; user id=myuser; password=mypass; database=test; pooling=false;" providerName="MySql.Data.MySqlClient"/>
to connect to your MySQL database

8) Browse to the default.aspx page and the sample should work.