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

ConnectionString 属性尚未初始化的问题

俺是小c 发布于 2013-09-28 20:47, 562 次点击
程序代码:
Public Class 登陆界面

    Dim objDataAdapter As New SqlDataAdapter


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


        Dim sqlstr As String
        sqlstr = "select * from admin admin where userid=' " & Trim(TextBox1.Text) & "'and password='" & Trim(TextBox2.Text) & "'"

        Using connection As New SqlConnection()
            connection.Open()


            Dim da As New SqlDataAdapter(sqlstr, connection)
            Dim ds As New DataSet()
            da.Fill(ds)
            connection.Close()
            Dim t = ds.Tables(0)
            If ds.Tables(0).Rows.Count = 0 Then
                MsgBox("你输入的账号或密码错误!", , "提示")
            Else
                主界面.Show()
                Me.Hide()


            End If

        End Using
提示错误:ConnectionString 属性尚未初始化!登陆验证的问题!如何解决,而且这代码应该有其他问题!求指导啊!!!!急死了,就没人知道吗?发了那么多帖子没人回!
4 回复
#2
yuccn2013-09-28 22:57
只能看看了
#3
adou2013-10-10 14:48
Using connection As New SqlConnection()
            connection.Open()
你的连接字符串呢?
#4
danliandeyu2013-11-08 14:49
回复 楼主 俺是小c
3楼正解,没有初始化数据库连接。
1