UC知道sql update 为什么更新不了数据库？？？
来源：百度知道 编辑：UC知道 时间：2024/06/23 02:50:53
源代码如下：
Sub Enter_Click(Sender As Object, E As EventArgs)
Dim conn As New SqlConnection("server=ctrlnz;database=biye;uid=sa;pwd=") '建立Connection对象
Dim str_update As String=" update stu_info set stu_age='" & stu_age.text & "',stu_birth='" & stu_birth.text & "',stu_phone='" & stu_phone.text & "',stu_address='" & stu_address.text & "' where stu_id='" & session("stu_id") & "'"
Dim cmd As New SqlCommand(str_update, conn)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
message.Text="修改成功"
End Sub
请高手指点。。。
Sub Enter_Click(Sender As Object, E As EventArgs)
Dim conn As New SqlConnection("server=ctrlnz;database=biye;uid=sa;pwd=") '建立Connection对象
Dim str_update As String=" update stu_info set stu_age='" & stu_age.text & "',stu_birth='" & stu_birth.text & "',stu_phone='" & stu_phone.text & "',stu_address='" & stu_address.text & "' where stu_id='" & session("stu_id") & "'"
Dim cmd As New SqlCommand(str_update, conn)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
message.Text="修改成功"
End Sub
请高手指点。。。
把你的语句打出来
直接放在查询分析器里调试就看明白了
这样我也看不懂。
应该没错啊，但这种update语句默认是更新全部字段的，有一个没设都报错的噢~
你最好还是把错误贴出来，要不很难猜出来~
看看这个 session("stu_id") 是否有数据！