[RESOLVED] [2005] Login form code (no errors, does nothing)

[BrailleSchool]

when the messagebox comes up, it has the number 2 in it.
i have gotten rid of the dataset and gone to datatable instead. whats the difference between the dataset and datatable?

still no change. first user has no issues. 2nd one cant be found. ugh

So you only get one record back when you are certain there is more than one record in your database table?

How many rows does this return?

        Dim strUsersSQL As String = "SELECT * " & _
                                    "FROM Users"
        Dim objUsersDa As New SqlClient.SqlDataAdapter(strUsersSQL, m_objCon)
        Dim dt As New DataTable()

        objUsersDa.Fill(dt)
        MessageBox.Show(dt.Rows.Count.ToString())