c# (winform)连接Mysql数据库的登录程序

首先引用

MySql.Data.dll

给出一个例子。

///

<summary>

///

运行查询

///

</summary>

///

<param

name="sql">单点查询语句</param>

///

<returns>DbDataReader数据阅读器</returns>

///

<exception

cref="ConnectionException">

///

如果打开连接失败，或者运行的语句不正确则抛出连接异常

///

YuanHeng.Product.EHotel.BusiLayer.DAO.ConnectionException

///

</exception>

public

MySqlDataReader

ExecuteQueryToRead(string

sql)

{

try

{

using

(MySqlConnection

connection

=

new

MySqlConnection(this.MySqlConnectionStr))

{

connection.Open()

log.Debug("ExecuteQueryToRead

->

"

+

sql)

MySqlCommand

cmd

=

new

MySqlCommand(sql,

connection)

cmd.CommandType

=

CommandType.Text

return

cmd.ExecuteReader()

}

}

catch

(MySqlException

ex)

{

log.Error(ex.Message,

ex)//记录异常

throw

new

ConnectionException("Sql其它异常"

+

ex.Message)

}

catch

(Exception

e)

{

log.Error(e.Message,

e)//记录异常

throw

new

ConnectionException("其它异常"

+

e.Message)

}

}

using MySql.Data.MySqlClient

MySqlConnection m_conn = new MySqlConnection()

m_conn.ConnectionString =

string.Format("Data Source={0}Initial Catalog={1}Persist Security Info=TrueUser ID={2}Password={3}", server, dbname, sqluser, sqlpass

)

m_conn.Open()

m_conn.Close()

这是复制我自己项目里的代码。。。

---