不明白什么问题 求高手指点

[pray0714]

程序
Dim reservertime As DateTime = DateTimePicker2.Value
Dim ReLiveInTime As DateTime = DateTimePicker1.Value
cmd1.CommandText = "insert rstable values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "',DateTimePicker2.Value ,'" & TextBox4.Text & "','" & TextBox8.Text & ",DateTimePicker1.Value,'" & TextBox7.Text & ")"
cnn.Open()
cmd1.ExecuteNonQuery()
cnn.Close()
Me.Close()

报错地方 cmd1.ExecuteNonQuery()

未处理的“System.Data.SqlClient.SqlException”类型的异常出现在 system.data.dll 中。

其他信息: 系统错误。

[magicbacon]

cmd1.CommandText = "insert rstable values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "',DateTimePicker2.Value ,'" & TextBox4.Text & "','" & TextBox8.Text & ",DateTimePicker1.Value,'" & TextBox7.Text & ")"

这一句请改为

cmd1.CommandText = "insert into rstable values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & DateTimePicker2.Value & "','" & TextBox4.Text & "','" & TextBox8.Text & "','" & DateTimePicker1.Value & "','" & TextBox7.Text & "')"

[magicbacon]

中间错了好几处。

[xiafan]

cmd1的连接字符串呢？

[pray0714]

改了，可是还是原来的问题

[pray0714]

只有这个窗体插入有问题，其他的都没问题

[水如烟]

代码写法只图一时痛快,看着会让人头疼.

分出来,数据归数据,界面归界面,中间用变量传递参数.

[magicbacon]

请把我改的copy到您原来的地方。

[pray0714]

没错，是复制到我原来的地方，还是不行呀

[magicbacon]

cmd1.CommandText = "insert into rstable values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','#" & DateTimePicker2.Value & "#','" & TextBox4.Text & "','" & TextBox8.Text & "','#" & DateTimePicker1.Value & "#','" & TextBox7.Text & "')"

这样呢？

[pray0714]

还是同样的结果