MySQL_CS.zip_asp mysql

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.