点击下载此文件 mysql for C#数据源驱动
第一步:请引用此压缩包中的MySql.Data.dll. 放在(bin)目录中
第二步:web.config 中的连接字符串:
<add key="mysqlconn" value="server=IP地址;database=数据库名;uid=登陆帐号;pwd=登陆密码;"></add>
第三步:
- using System;
- using System.Data;
- using System.Configuration;
- using System.Web;
- using System.Web.Security;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.WebControls.WebParts;
- using System.Web.UI.HtmlControls;
- using MySql.Data.Types;
- using MySql.Data.MySqlClient;
- /// <summary>
- /// C#操作mysql基类
- /// </summary>
- public class MySqlobj
- {
- private MySqlConnection conn;
- private MySqlCommand com;
- private bool _alreadyDispose = false;
- #region 构造与柝构
- public MySqlobj()
- {
- try
- {
- conn = new MySqlConnection(ConfigurationManager.AppSettings["mysqlconn"]);
- conn.Open();
- com = new MySqlCommand();
- com.Connection = conn;
- }
- catch (Exception ee)
- {
- throw new Exception("连接数据库出错");
- }
- }
- ~MySqlobj()
- {
- Dispose();
- }
- protected virtual void Dispose(bool isDisposing)
- {
- if (_alreadyDispose) return;
- if (isDisposing)
- {
- // TODO: 此处释放受控资源
- if (com != null)
- {
- com.Dispose();
- }
- if (conn != null)
- {
- try
- {
- conn.Close();
- conn.Dispose();
- }
- catch (Exception ee)
- {
- }
- finally
- {
- conn = null;
- }
- }
- }
- // TODO: 此处释放非受控资源。设置被处理过标记
- _alreadyDispose = true;
- }
- #endregion
- #region IDisposable 成员
- public void Dispose()
- {
- Dispose(true);
- GC.SuppressFinalize(this);
- }
- #endregion
- #region 获取DataSet
- public DataSet GetDataSet(string sqlString)
- {
- DataSet ds = new DataSet();
- try
- {
- MySqlDataAdapter da = new MySqlDataAdapter(sqlString, conn);
- da.Fill(ds);
- }
- catch (Exception ee)
- {
- throw new Exception("SQL:" + sqlString + "<br />" + ee.Message.ToString());
- }
- return ds;
- }
- #endregion
- #region 执行插入或删除操作
- public void ExecuteNonQuery(string sqlString)
- {
- int ret = 0;
- com.CommandText = sqlString;
- com.CommandType = CommandType.Text;
- try
- {
- ret = com.ExecuteNonQuery();
- }
- catch (Exception ee)
- {
- throw new Exception("SQL:" + sqlString + "<br />" + ee.Message.ToString());
- }
- finally
- {
- com.Dispose();
- }
- }
- #endregion
- }