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.
MySQL_CS.zip （8个子文件） 
MySQL_C# 
Directions on how to use this sample.txt 2KB MySQL 
Default.aspx 2KB Web.config 2KB App_Code MessagesDB.cs 3KB MessageItem.cs 853B App_Data Bin MySql.Data.dll 140KB Default.aspx.cs 411B About_This_sample.htm 49KB资源评论
