ASP.NET操作SQL的问题

[gdutmo]

Dim sql As String
Dim myconnection As New SqlClient.SqlConnection()
myconnection = New SqlClient.SqlConnection(stringcon)
Dim mycommand As New SqlClient.SqlCommand(sql, myconnection)
mycommand.Connection.Open()
Dim mytrans As SqlClient.SqlTransaction
mytrans = myconnection.BeginTransaction
Try

sql = "INSERT INTO T (KC) VALUES ('CC00000001')"
mycommand.CommandType = CommandType.Text
mycommand.ExecuteNonQuery()
mytrans.Commit()
Catch
mytrans.Rollback()
Finally
myconnection.Close()
mycommand.Dispose()
myconnection.Dispose()
End Try

它老是不能更新数据库,但那SQL语句是正确的，能在SQL中运行，请各位帮忙

[Abac]

Dim sql As String
Dim myconnection = New SqlClient.SqlConnection(stringcon)
myconnection.Open().
Dim mycommand As New SqlClient.SqlCommand()
mycommand.Connection = myconnection
Dim mytrans As SqlClient.SqlTransaction
mytrans = myconnection.BeginTransaction
Try

sql = "INSERT INTO T (KC) VALUES ('CC00000001')"
mycommand.CommandType = CommandType.Text
mycommand.CommandText = sql '漏掉了这一句
mycommand.ExecuteNonQuery()
mytrans.Commit()
Catch
mytrans.Rollback()
Finally
myconnection.Close()
mycommand.Dispose()
myconnection.Dispose()
End Try

[suguanqun]

sql = "INSERT INTO T (KC) VALUES ('CC00000001'）
SqlCommand cmd=new SqlCommand(); 　　 　　
cmd.CommandText=sql;
cmd.ExecuteNonQuery();

[zhujiechang]

关键的一句:Command命令.Transaction=mytran;需要指定对象事务.
对于sql语句的执行是否正确,应该是将try catch段取掉来判断.

[gdutmo]

我还是不太清楚能详细说吗？我是用VB。NET的不是用C#

[rosegirlsun2000]

第3行是不是应该写成STRINGCONN呢？

[yaotiebing]

sql = "INSERT INTO T (KC) VALUES ('CC00000001')"
mycommand.CommandType = CommandType.Text
mycommand.Transaction=mytran;
mycommand.ExecuteNonQuery()
mytrans.Commit()

myconnection.Close()
mycommand.Dispose()
myconnection.Dispose()
看看有什么错

[gdutmo]

不意思少打了mycommand.CommandText = sql,但还是不行说MYTRANS=nothing的。

[gdutmo]

晕死是怎老是rollback 有谁能救救我啊分不够还可以再加啊。谢各位帮忙

[gdutmo]

没人能帮我吗？我急着解决此问题