ASP.NET操作MySql数据库的实例代码讲解

using MySql.Data.MySqlClient; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Login : System.Web.UI.Page {   public static class MySqlHelper   {     public static int ExecuteNonQuery(string connectionString, CommandType commandtype, string commandText)     {       return ExecuteNonQuery(connectionString, commandtype, commandText, null);     }     public static int ExecuteNonQuery(string connectionString, CommandType commandtype, string commandText, params MySqlParameter[] commandParameters)     {       if (string.IsNullOrEmpty(connectionString))       {         throw new Exception("connectionString exception");       }       int result = 0;       MySqlConnection con = null;       try       {         using (con = new MySqlConnection(connectionString))         {           con.Open();           MySqlCommand command = new MySqlCommand(commandText, con);           command.CommandType = commandtype;           result = command.ExecuteNonQuery();         }         return result;       }       catch (Exception ex)       {         throw ex;       }       finally       {         if (con.State == ConnectionState.Open)         {           con.Close();         }       }     }   }   protected void Page_Load(object sender, EventArgs e)   {     string connectionString = "server=localhost;uid=root;pwd=;database=zentaopro;";     LogManage_SqlDate.WriteLog("connectionString=:" + connectionString);     string sql = "insert user(account) values('china2')";     MySqlHelper.ExecuteNonQuery(connectionString, CommandType.Text, sql);     Console.Read();   } }