求C# winform开发连接MySql

zhoutengxiao 2011-03-31 03:57:54

C# 怎样使用MySql的事务？？

...全文

295 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

zhoutengxiao 2011-04-01

打赏
举报

恩，谢谢大家了

dusenyao 2011-03-31

打赏
举报

Transaction 是事务？还是Trigger?
我觉得除非有必要，还是用NHibernate或者EF 4.1之类的处理数据吧

这里有Reference
http://dev.mysql.com/doc/refman/5.0/es/connector-net-examples-mysqltransaction.html

半截木头 2011-03-31

打赏
举报

//引用
using System.Data.SqlClient;

string strConnection = "server = 服务器名,database = 数据库名称,uid = 登入名,pwd = 密码";
SqlConnection connection = new SqlConnection(strConnection);
try
{
//打开数据库链接
connection.Open();

SqlCommand cmd = new SqlCommand();

//cmd所使用的链接
cmd.Connection = connection;

//提交sql语句文本
cmd.CommandText = "select * from UserInfo";

//事物
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
//关闭数据库链接
connection.Close();
}

zilong4460072 2011-03-31

打赏
举报



//连接数据库字符串

            string connStr = "User Id=" + userName + ";Host=" + host + ";Database=" + dataBase + ";password=" + passWord + "";

            MySqlConnection conn = new MySqlConnection(connStr);

zilong4460072 2011-03-31

打赏
举报



using (MySqlConnection conn = MyConn.GetConnection())

            {

                try

                {

                    conn.Open();

                    Trans = conn.BeginTransaction();

                    MySqlCommand cmd = new MySqlCommand();

                    cmd.Connection = conn;

                    cmd.Transaction = Trans;

                    cmd.CommandText = "select * from table";

                    cmd.ExecuteNonQuery();

                    //事务提交

                    Trans.Commit();

                }

                catch (DbException e)

                {

                    //事务回滚

                    if (Trans != null)

                        Trans.Rollback();

                }

                finally

                {

                    conn.Close();

                }

            }