Question

VB.NET ExecuteNonQuery 怎么用，返回总是0

Dim DBConnectionStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\StudentManage.mdb"
Dim objConn As New OleDb.OleDbConnection
objConn.ConnectionString = DBConnectionStr
Dim sqlpassword As String = password.Text.Trim()
Dim sqlusername As String = username.Text.Trim()
objConn.Open()
Dim command As OleDb.OleDbCommand = New OleDb.OleDbCommand("select * from [user] where username='" & username.Text & "' and password='" & password.Text & "'", objConn)
'where username='" & sqlusername & "' and password='" & sqlpassword & "'", objConn)
Dim n As Integer
n = command.ExecuteNonQuery()
MsgBox(n, , "登陆")
If n = 0 Then
MsgBox("登陆失败", , "登陆")
Else
MsgBox("登陆成功", , "登陆")
End If
objConn_lixingang.Close()
无论输入什么不管数据库中有还是没有都是0，求大神解！

Answer 1

你现在提供的只是一个连接数据的字符串，最好把你的SQL代码都给出来，才能知道你的问题出在那里。

追问

用的ACCESS，

够吗？