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

数据库  /  管理员 发布于 7年前   183

一、把MySql.Data.dll放到BIN目录下。 

二、这是aspx.cs的全部源码，修改参数直接运行即可！  

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();   } } 

以上所述是小编给大家介绍的ASP.NET操作MySql数据库的实例代码讲解，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对站的支持！