MySqlTransaction tran = DefSqlCon.BeginTransaction();
DefSqlCon.Open();
MySqlCommand sqlcmd = new MySqlCommand(sql, DefSqlCon);
sqlcmd.Transaction = tran;
改称
DefSqlCon.Open();
MySqlTransaction tran = DefSqlCon.BeginTransaction();
MySqlCommand sqlcmd = new MySqlCommand(sql, DefSqlCon);
sqlcmd.Transaction = tran;
DefSqlCon.Open();
MySqlCommand sqlcmd = new MySqlCommand(sql, DefSqlCon);
sqlcmd.Transaction = tran;
改称
DefSqlCon.Open();
MySqlTransaction tran = DefSqlCon.BeginTransaction();
MySqlCommand sqlcmd = new MySqlCommand(sql, DefSqlCon);
sqlcmd.Transaction = tran;
解决方案 »
- 求助:如何在.net实体类的属性字段标识上数据库对应的关键字属性
- 上传文件的问题,请教高手
- 我怎么把这个小页面中的值传到cust_import.aspx中???
- 发布出来的文章为什么标题没有读了来,请高手支招.
- 在HTM网页中可以放入自定义用户控件吗!!要怎么放呀
- 唉。。再问个很傻的问题。。不要打我三
- 请问如何在代码中动态实现“模拟”相关用户,而不是在web.config中设置???
- 如何对datagrid模版列中的droplist控件动态邦定?并且selectedvalue也是动态的??
- 防止自动注册机问题~!
- 怎样记住这些索引值,在对象浏览器内可以查找吗?是哪个类的?
- 【被押宝游戏害惨了】
- 下载的VS 2003程序怎么转化成2005就不行了?麻烦帮忙,谢谢
应该是这句,你没有开始事务,然后在后面用
tran.Commit();是不可以的!
[WebMethod]
public string InsertData(string newid title content)
{
try
{
string result = "";
string sql = "insert into t1(newid title) values ('" + newid + "','" + title + "')";
string sql1 = "insert into t2(newid content) values ('" + newid + "','" + content + "')";
MySqlConnection DefSqlCon = new MySqlConnection("server=192.168.0.1;user id=net;password=123;database=test");
DefSqlCon.Open(); //放在这就可以了,呵呵,是不是不能同时插入两个表啊?提示错误
MySqlTransaction tran = DefSqlCon.BeginTransaction();
MySqlCommand sqlcmd = new MySqlCommand(sql, DefSqlCon);
sqlcmd.Transaction = tran;
sqlcmd.Connection = DefSqlCon;
sqlcmd.ExecuteNonQuery();
MySqlCommand sqlcmd1 = new MySqlCommand(sql1, DefSqlCon);
sqlcmd1.Transaction = tran;
sqlcmd1.Connection = DefSqlCon;
sqlcmd1.ExecuteNonQuery();
tran.Commit();
result = "1";
return result;