各位，能帮助看看这个小问题吗？

[zhangzhicong]

Dim sqlstring As String = "SELECT * FROM [user] where username='" & Trim(Me.txtUserID.Text) & "' and [password]='" & Trim(Me.txtPassword.Text) & "'"
Dim conn As New SqlConnection("server=me;database=aspnet;user id=sa;password=123;")
Dim cmd As New SqlCommand(sqlstring, conn)
Dim i As Integer = 0
Try
conn.Open()
i = cmd.ExecuteNonQuery '可以这样用的吗？？
If i > 0 Then
Response.BufferOutput = True
Page.Response.Redirect("main.aspx")

Else
Response.Write("<script language='javascript'>alert('用户名或者密码错误！！')</script>")
Me.txtUserID.Text = ""
Me.txtPassword.Text = ""
End If
conn.Close()
Catch ex As Exception
lblMessage.Text = ex.Message
conn.Close()
End Try

就是cmd.ExecuteNonQuery 的返回值，好象是不能这样的吧
是吗？？

[aaajedll]

up

[aftnTea]

用ExecuteScalar方法可以返回一个值,
如:
int i =(int)cmd.ExecuteScalar();

ExecuteNonQuery 用于执行不需要返回结果的命令

[Jrac]

晕，cmd.ExecuteNonQuery是没有返回值好吧