You have to create query like this, and read the values and convert it to object if required.
"select * from Users where Username = '" + Login1.UserName + "' and Password = '" + Password + "'"
Good practice is to use parameterized query or stored procedure instead.