aspnet链接mysql

先去MySql网站去下载一个DLL文件：

mysql-connector-net

查询代码

using MySql.Data.MySqlClient;

public static string SelectUserInfo_MySql()
        {
            string bookres = "";
            using (MySqlConnection myConnection = new MySqlConnection("server=localhost;user id=root;password=;database=simple"))
            {
                using (MySqlCommand myCommand = new MySqlCommand("select * from test", myConnection))
                {
                    myConnection.Open();
                    myCommand.ExecuteNonQuery();
                    MySqlDataReader myDataReader = myCommand.ExecuteReader();

                    while (myDataReader.Read())
                    {
                        bookres += myDataReader["uid"];
                        bookres += myDataReader["username"];
                        bookres += myDataReader["address"];
                    }
                }
            }
            return bookres;
        }

 

添加代码：

MySql.Data.MySqlClient.MySqlConnection conn;

MySql.Data.MySqlClient.MySqlCommand cmd;



conn = new


 MySql.Data.MySqlClient.MySqlConnection();



cmd = new


 MySql.Data.MySqlClient.MySqlCommand();





conn.ConnectionString = strConnection;



try


{



 conn.Open();



 cmd.Connection = conn;



 cmd.CommandText = "INSERT INTO myTable VALUES(NULL, @number, @text)"


;





 cmd.Prepare();



 cmd.Parameters.AddWithValue("@number"


, 1


);

 cmd.Parameters.AddWithValue("@text"


, "One"


);





 for


 (int


 i=1


; i <= 1000


; i++)



 {



       cmd.Parameters["@number"


].Value = i;

       cmd.Parameters["@text"


].Value = "A string value"


;

       cmd.ExecuteNonQuery();

 }



}catch


 (MySql.Data.MySqlClient.MySqlException ex)



{





 MessageBox.Show("Error "


+ ex.Number + " has occurred: "


+ ex.Message, "Error"


, MessageBoxButtons.OK, MessageBoxIcon.Error);





}