我用的是VB2005數據庫是SQL SERVER 2000 但是每次聯接時，總是提示連接SQL SERVER 2005 失敗。
因為我沒有裝SQL 2005
還是我的代碼打錯了

        Dim i As Integer
        Dim strcon, strcmd As String
        strcon = "Persist Security Info=False;User ID=sa;Initial Catalog=.;Data Source=test;"
        Dim sqlcon As SqlConnection = New SqlConnection(strcon)
        sqlcon.Open()
        strcmd = "select * from t_login"
        'where tda='1'"
        Dim sqlcmd As SqlCommand = New SqlCommand(strcmd, sqlcon)
        Dim dr As SqlDataReader
        dr = sqlcmd.ExecuteReader
        Do While dr.Read()
            'TextBox1.Text = RS_up.Tables(0).Rows(1)("id")
            'For i = 0 To dr.FieldCount - 1
            If TextBox1.Text = dr.Item(3) Then
                MsgBox("a")
                Exit Sub
            End If
            'Exit For
            'Next
        Loop

是的，謝謝你
再問下，如果我是要判斷輸入到文本的內容是否在數據庫里面有沒有要怎么做呢
還有為什么我放到模塊里面會出錯

[[it] 本帖最后由 jxyga111 于 2008-11-14 10:03 编辑 [/it]]

必需是宣告strcon
但是我申明了Public strcon As String