问题描述
[WebMethod]publicstringInsertData(stringnewidtitlecontent){try{stringresult="";stringsql="insertintot1(newidtitle)values('"+newid+"','"+title+"')";stringsql1="insertintot2(newidcontent)values('"+newid+"','"+content+"')";MySqlConnectionDefSqlCon=newMySqlConnection("server=192.168.0.1;userid=net;password=123;database=test");MySqlCommandsqlcmd=newMySqlCommand(sql,DefSqlCon);sqlcmd.Transaction=tran;sqlcmd.Connection=DefSqlCon;sqlcmd.ExecuteNonQuery();MySqlCommandsqlcmd1=newMySqlCommand(sql1,DefSqlCon);sqlcmd1.Transaction=tran;sqlcmd1.Connection=DefSqlCon;sqlcmd1.ExecuteNonQuery();tran.Commit();result="1";returnresult;}catch(Exceptionerr){returnerr.ToString();}finally{}
解决方案
解决方案二:
DefSqlCon.open()
解决方案三:
...DefSqlCon.open()MySqlCommandsqlcmd=newMySqlCommand(sql,DefSqlCon);sqlcmd.Transaction=tran;
解决方案四:
引用楼主enasp的帖子:
C#code[WebMethod]publicstringInsertData(stringnewidtitlecontent){try{stringresult="";stringsql="insertintot1(newidtitle)values('"+newid+"','"+title+"')";stringsql1="insertintot2(newidcontent)values('"+newid+"','"+content+"')";MySqlConnectio…
[WebMethod]publicstringInsertData(stringnewidtitlecontent){try{stringresult="";stringsql="insertintot1(newidtitle)values('"+newid+"','"+title+"')";stringsql1="insertintot2(newidcontent)values('"+newid+"','"+content+"')";MySqlConnectionDefSqlCon=newMySqlConnection("server=192.168.0.1;userid=net;password=123;database=test");MySqlCommandsqlcmd=newMySqlCommand(sql,DefSqlCon);sqlcmd.Transaction=tran;sqlcmd.Connection=DefSqlCon;sqlcmd.ExecuteNonQuery();MySqlCommandsqlcmd1=newMySqlCommand(sql1,DefSqlCon);sqlcmd1.Transaction=tran;sqlcmd1.Connection=DefSqlCon;DefSqlCon.Open();sqlcmd1.ExecuteNonQuery();tran.Commit();result="1";returnresult;}catch(Exceptionerr){returnerr.ToString();}finally{}
解决方案五:
DefSqlCon.open()连接没有打开
解决方案六:
打开了也不行啊
解决方案七:
<?xmlversion="1.0"encoding="utf-8"?><stringxmlns="http://tempuri.org/">System.InvalidOperationException:Theconnectionisnotopen.在MySql.Data.MySqlClient.MySqlConnection.BeginTransaction(IsolationLeveliso)在MySql.Data.MySqlClient.MySqlConnection.BeginTransaction()在WebService.InsertData