62,272
社区成员
发帖
与我相关
我的任务
分享着急!access数据库更新问题
Dim conn As OleDbConnection
Dim cmdupdate As OleDbCommand
Dim newid As String
newid = Request.Params("id")
cmdupdate = New OleDbCommand("update users set name='" + name.Text + "',pass='" + pass.Text + "' where id=" + newid, conn)
conn.Open()
cmdupdate.ExecuteNonQuery()
conn.Close()
Response.Redirect("success.aspx")
Dim cmdupdate As OleDbCommand
Dim newid As String
newid = Request.Params("id")
cmdupdate = New OleDbCommand("update users set name='" + name.Text + "',pass='" + pass.Text + "' where id=" + newid, conn)
conn.Open()
cmdupdate.ExecuteNonQuery()
conn.Close()
Response.Redirect("success.aspx")
...全文
请发表友善的回复…
发表回复
amjiahe 2004-07-10
- 打赏
- 举报
欢迎到http://ttxx.com去看下
yungboy 2004-07-10
- 打赏
- 举报
cmdupdate = New OleDbCommand("update users set users.name='" & name.Text & "',users.pass='" & pass.Text & "' where (id=@id), conn)
定义id
cmdupage.parameters("@id").value=(给id赋值)
定义id
cmdupage.parameters("@id").value=(给id赋值)
11114164 2004-07-09
- 打赏
- 举报
自己顶
11114164 2004-07-08
- 打赏
- 举报
cmdupdate = New OleDbCommand("update users set name='" & name.Text & "',pass='" & pass.Text & "' where id=" & newid, conn)
和cmdupdate = New OleDbCommand("update users set name='" + name.Text + "',pass='" + pass.Text + "' where id=" + newid, conn)
是一样的
和cmdupdate = New OleDbCommand("update users set name='" + name.Text + "',pass='" + pass.Text + "' where id=" + newid, conn)
是一样的
Alexandria 2004-07-08
- 打赏
- 举报
cmdupdate = New OleDbCommand("update users set name='" & name.Text & "',pass='" & pass.Text & "' where id=" & newid, conn)
Alexandria 2004-07-08
- 打赏
- 举报
Dim conn As New OleDbConnection("server=ServiceName;database=dbName;uid=UserName;pwd=Password;pooling=true")
