ASP.NET操作mysql数据库的实例（傻瓜都能看懂，已测试过）

来源：互联网发布：淘宝店铺公告怎么修改编辑：程序博客网时间：2024/05/16 10:53

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

在此基础上做了一个傻瓜版的，感谢此网址提供解决方案：http://www.cnblogs.com/zjypp/p/3327170.html

0 0