How to use to values returned in a SELECT query ???

Hi all, simples one for you...

How can I use / retrieve two values from a SELECT query? I have done it before but cannot remember how to do it...!!!

EXAMPLE:

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["UserConnectionString"].ConnectionString);
		con.Open();
		string cmdStr2 = "SELECT Password FROM UserTable WHERE EmailAddress= '" + UserEmail + "'";
		SqlCommand checkPword = new SqlCommand(cmdStr2, con);
		string password = checkPword.ExecuteScalar().ToString();
		con.Close();

Here im just getting the password, but what about if I was doing SELECT Username, Password FROM UserTable........ How woud I get and use those two values into two separate variables..?

Thanks!

Re: How to use to values returned in a SELECT query ???

return the values into a DataSet and then you can consume the rows.

Re: How to use to values returned in a SELECT query ???

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["UserConnectionString"].ConnectionString))
{
		SqlCommand Comm1 = new SqlCommand("SELECT Password,username FROM UserTable WHERE EmailAddress= '" + UserEmail + "'", con);

		con.Open();
		SqlDataReader DR1 = Comm1.ExecuteReader();

		if (DR1.Read()) {
			string password = DR1.GetValue(0).ToString();
			string username = DR1.GetValue(1).ToString();
		}

		con.Close();

	}

Re: How to use to values returned in a SELECT query ???

Thank you....