mysql中sqlexception分类_C#中出现问题：“System.Data.SqlClient.SqlException”类型的异常在 System.Data.dll 中发生...

展开全部

下面是我们用的连接数据库的代码，直接拷32313133353236313431303231363533e4b893e5b19e31333365653862过去把。引用下MYsql那个dll就行了。

至于怎么改连接的用户名和密码什么的你应该知道吧。就是下面这个图片。

using System;

using System.Collections.Generic;

using System.Data;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using MySql.Data;

using MySql.Data.MySqlClient;

namespace MySQLNew

{

public class MysqlNew

{

private string _strServerAddress;

///

/// MySQL服务器地址

///

public string strServerAddress

{

get

{

return _strServerAddress;

}

set

{

this._strServerAddress = value;

}

}

private string _strServerPort;

///

/// MySql服务器端口

///

public string strServerPort

{

get

{

return _strServerPort;

}

set

{

this._strServerPort = value;

}

}

private string _strServerUser;

///

/// MySql服务器用户名

///

public string strServerUser

{

get

{

return _strServerUser;

}

set

{

this._strServerUser = value;

}

}

private string _strServerPwd;

///

/// MySql服务器密码

///

///

public string strServerPwd

{

get

{

return _strServerPwd;

}

set

{

this._strServerPwd = value;

}

}

private string _strServerDatabase;

///

/// MySql服务器数据库

///

///

public string strServerDatabase

{

get

{

return _strServerDatabase;

}

set

{

this._strServerDatabase = value;

}

}

private string strConnectionString;

object objLocker = new object();

public MysqlNew()

{

this.strServerAddress = "localhost";

this.strServerPort = "3306";

this.strServerUser = "root";

this.strServerPwd = "root";

this.strServerDatabase = "test";

strConnectionString = String.Format("server={0};user id={1}; password={2}; database={3}; pooling=false;port={4}",

strServerAddress, strServerUser, strServerPwd, strServerDatabase, strServerPort);

}

public int ExecuteSql(string sCmd)

{

return this._ExecuteSql(sCmd);

}

private int _ExecuteSql(string sCmd)

{

lock (objLocker)

{

try

{

using (MySqlConnection mCnn = new MySqlConnection(strConnectionString))

{

mCnn.Open();

MySqlCommand cmd = new MySqlCommand(sCmd, mCnn);

int i = cmd.ExecuteNonQuery();

mCnn.Close();

mCnn.Dispose();

return i;

}

}

catch

{

return 0;

}

}

}

public DataTable GetDataTableByCmd(string sCmd, out string sErrMsg)

{

return _GetDataTableByCmd(sCmd, out sErrMsg);

}

private DataTable _GetDataTableByCmd(string sCmd, out string sErrMsg)

{

lock (objLocker)

{

try

{

using (MySqlConnection mCnn = new MySqlConnection(strConnectionString))

{

mCnn.Open();

string sSql = sCmd;

MySqlDataAdapter adpt = new MySqlDataAdapter(sSql, mCnn);

DataTable mTable = new DataTable();

adpt.Fill(mTable);

mCnn.Close();

mCnn.Dispose();

sErrMsg = "";

return mTable;

}

}

catch (Exception err)

{

sErrMsg = err.Message;

return null;

}

}

}

public DataTable GetDataTable(string tableName, out string sErrMsg)

{

return _GetDataTable(tableName, out sErrMsg);

}

private DataTable _GetDataTable(string tableName, out string sErrMsg)

{

lock (objLocker)

{

try

{

using (MySqlConnection mCnn = new MySqlConnection(strConnectionString))

{

mCnn.Open();

string sSql = string.Format("select * from {0}", tableName);

MySqlDataAdapter adpt = new MySqlDataAdapter(sSql, mCnn);

DataTable mTable = new DataTable();

adpt.Fill(mTable);

mCnn.Close();

mCnn.Dispose();

sErrMsg = "";

return mTable;

}

}

catch (Exception err)

{

sErrMsg = err.Message;

return null;

}

}

}

}

}