注册 登录
编程论坛 ASP.NET技术论坛

.NET语句这哪错了?怎么不能更改?

lsz3344 发布于 2007-04-24 16:38, 442 次点击
Dim conn As SqlConnection = New SqlConnection("database=new;uid=sa;pwd=;server=127.0.0.1")
Dim sqlstr As String = "select * from usertable where where username=" & Session("username") & "and userpsd='" & userpsd.Text & "'"
Dim da As New SqlDataAdapter(sqlstr, conn)
conn.Open()
Dim ds As New DataSet
da.Fill(ds, "usertable")
If ds.Tables("usertable").Rows.Count = 0 Then
Response.Write("<script>alert('原密码输入不正确!')</script>")
Else

Dim comm As New SqlCommand("Update usertable Set userpsd='" & userpsd1.Text & " ' where username ='" & Session("username") & "' ", conn)
comm.ExecuteNonQuery()
Response.Write("<script>alert('修改成功!')</script>")
End If
conn.Close()
3 回复
#2
lsz33442007-04-24 16:39
不能得到当前的username的值
#3
bygg2007-04-24 17:05
以下是引用lsz3344在2007-4-24 16:38:08的发言:
Dim conn As SqlConnection = New SqlConnection("database=new;uid=sa;pwd=;server=127.0.0.1")
Dim sqlstr As String = "select * from usertable where where username='" & Session("username").ToString() & "'" & "and userpsd='" & userpsd.Text & "'"
Dim da As New SqlDataAdapter(sqlstr, conn)
conn.Open()
Dim ds As New DataSet
da.Fill(ds, "usertable")
If ds.Tables("usertable").Rows.Count = 0 Then
Response.Write("<script>alert('原密码输入不正确!');</script>")
Else

Dim comm As New SqlCommand("Update usertable Set userpsd='" & userpsd1.Text & " ' where username ='" & Session("username").ToString() & "' ", conn)
comm.ExecuteNonQuery()
Response.Write("<script>alert('修改成功!');</script>")
End If
conn.Close()

其实这样的问题你加个 try..catch..就什么问题都知道了.

#4
lsz33442007-04-24 17:09
呵呵,加哪啊?我是刚学啊,还不懂哦!~~
1