Question

VB.NET INSERT时ExecuteNonQuery: Connection 属性尚未初始化

Sqlcn5.ConnectionString = "Server=" & ServerIP & ";Database=HUAX;Uid=sa;Pwd=123;"
If Sqlcn5.State = True Then Sqlcn5.Close()
Sqlcd5.CommandText = "INSERT INTO Mt " & _
"(destination,[content],userSendDate)" & _
"VALUES(@destination,@[content],@userSendDate)"
Sqlcd5.Parameters.AddWithValue("@destination", TextBox1.Text)
Sqlcd5.Parameters.AddWithValue("@[content]", TextBox2.Text)
Sqlcd5.Parameters.AddWithValue("@userSendDate", Now.ToString)
Sqlcn5.Open() '打开连接
Dim EfectRows As Integer = Sqlcd5.ExecuteNonQuery() '执行操作并将影响的行数赋给变量
Sqlcn5.Close() '关闭连接
当执行到Sqlcd5.ExecuteNonQuery() 时便报错了，搜了很多资料都没有解决。

Answer 1

Sqlcd5=sqlcn5.createcommand

追问

谢谢你的回答，我查到原因了，要加入这句Sqlcd5.Connection = Sqlcn5就好了。