myconn = New SqlConnection("server=localhost;database=database;uid=sa;pwd=sa")
myadapter = New SqlDataAdapter(sqlstr, myconn)
ds = New DataSet
myadapter.Fill(ds) Dim sqlstr As String
Dim ds As DataSet
ds = New DataSet
If pwdstr = "" Then
sqlstr = "select * from register where id='" + userstr.Trim + "' and rkey is null"
Else
sqlstr = "select * from register where id='" + userstr.Trim + "' and rkey='" + pwdstr + "'"
End If
fill(sqlstr)
If ds.Tables(0).Rows.Count = 0 Then
close()
Return -1
End If
ds.Clear()
close()
Return 1
myadapter = New SqlDataAdapter(sqlstr, myconn)
ds = New DataSet
myadapter.Fill(ds) Dim sqlstr As String
Dim ds As DataSet
ds = New DataSet
If pwdstr = "" Then
sqlstr = "select * from register where id='" + userstr.Trim + "' and rkey is null"
Else
sqlstr = "select * from register where id='" + userstr.Trim + "' and rkey='" + pwdstr + "'"
End If
fill(sqlstr)
If ds.Tables(0).Rows.Count = 0 Then
close()
Return -1
End If
ds.Clear()
close()
Return 1
可是又有新的问题~
运行显示:未将对象引用设置到对象的实例。 If ds.Tables(0).Rows.Count = 0 Then 报错!
这又是为什么~
成员方法A:
myconn = New SqlConnection("server=localhost;database=database;uid=sa;pwd=sa")
myadapter = New SqlDataAdapter(sqlstr, myconn)
ds = New DataSet
myadapter.Fill(ds)成员方法B:
Dim sqlstr As String
If pwdstr = "" Then
sqlstr = "select * from register where id='" + userstr.Trim + "' and rkey is null"
Else
sqlstr = "select * from register where id='" + userstr.Trim + "' and rkey='" + pwdstr + "'"
End If
fill(sqlstr)
If ds.Tables(0).Rows.Count = 0 Then
close()
Return -1
End If
ds.Clear()
close()
Return 1
O(∩_∩)O哈哈~对了~~
非常非常非常的感谢你~