注册 登录
编程论坛 VB.NET论坛

新手学VB~~登录窗口错误~帮忙看看~

jonsonfox 发布于 2010-03-20 15:05, 1093 次点击
Dim connstr As String
        Dim providername1 As SqlClient.SqlConnection
        connstr = "Data Source=WWW-585271DDAED;Initial Catalog=systemdate;Persist Security Info=True;User ID=sa;Password=123456"
        providername1 = New System.Data.SqlClient.SqlConnection(connstr)
        providername1.Open()
        Dim sqlcmd As SqlClient.SqlCommand
        Dim sqlcmdstr As String
        sqlcmdstr = "select * form denlu where username ='" & UsernameTextBox.Text & "' and password ='" & PasswordTextBox.Text & "'"
        sqlcmd = New SqlClient.SqlCommand(sqlcmdstr, providername1)
        Dim rd As SqlClient.SqlDataReader
       rd = sqlcmd.ExecuteReader  ‘怎么提示这里错误啊~~
        If rd.Read() Then
            Dim form1 As New Form1
            form1.Show()
            Me.Hide()
        Else
            MessageBox.Show("帐号密码错误!", "错误提示!", MessageBoxButtons.OK, MessageBoxIcon.Error)
            UsernameTextBox.Text = ""
            PasswordTextBox.Text = ""
            UsernameTextBox.Focus()
        End If
7 回复
#2
czyzhuo2010-03-22 14:22
少了一个括号,
rd = sqlcmd.ExecuteReader()
#3
czyzhuo2010-03-24 10:29
问题解决了吗?
如果没有,就把错误贴上来,大家可以参考一下
#4
ydge20092010-03-28 14:39
看不懂啊  怎么办啊  
#5
jonsonfox2010-03-29 13:58
还是不行啊~~~
只有本站会员才能查看附件,请 登录
#6
czyzhuo2010-04-02 10:12
你的SQL语句错了
应该把"form"改成"from"

select * from denlu where usernamet='
#7
xlh00532010-04-09 15:59
from 跟 form 不要搞混淆了,建议去看看sql语句
1