关于 mycon.BeginTransaction()问题
Public Function myExecSQL(ByVal constr As String, ByVal mysql As String) As String

Dim mycon As New SqlConnection(constr)
Dim mycom As New SqlCommand(mysql, mycon)
Dim myTran As SqlTransaction

mycon.Open()
myTran = mycon.BeginTransaction()

Try
mycom.ExecuteNonQuery()
myTran.Commit()
Catch ex As Exception
myTran.Rollback()
Return "False "
Exit Function
Finally
mycon.Close()
End Try

Return "True "

End Function

上面的过程哪里出错了？一执行到mycom.ExecuteNonQuery()这里好像就出错了。

[解决办法]
看看sql语句是不是对了
[解决办法]
...

Try
mycom.Transaction = myTran '这里加上这个
mycom.ExecuteNonQuery()
myTran.Commit()
...