Newbie With An Easy Compilation Error Question.

I've been looking over this and can't see anything wrong. Can anyone shed some light on this for me?


------------------





Compilation Error


Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.





Compiler Error Message: CS0117: 'System.Data.SqlClient.SqlConnection' does not contain a definition for 'ExecuteReader'





Source Error:











Line 16: SqlCommand myComm = new SqlCommand("SELECT users, password FROM users WHERE username='" + username + "' AND password='" + password + "'", myConn);


Line 17: myConn.Open();


Line 18: SqlDataReader myReader = myConn.ExecuteReader();


Line 19: do


Line 20: {








Source File: D:Inetpubhoteladvisor estLogin.aspx Line: 18








void Login(string username, string password)


{


SqlConnection myConn = new SqlConnection ("server = client1; uid = dbadmin; pwd = dbadmin; database = hotels");


SqlCommand myComm = new SqlCommand("SELECT users, password FROM users WHERE username='" + username + "' AND password='" + password + "'", myConn);


myConn.Open();


SqlDataReader myReader = myConn.ExecuteReader();


do


{


while (reader.Read())


{


if (username == myReader.GetString(1) && password == myReader.GetString(2))


{


messages.Text = "Your login was successful!";


}


else


{


messages.Text = " Your login was unsuccessful!";


}


}


}


while (reader.NextResult());


myReader.Close();


myConn.Close();


}


void Submit_Click(Object sender, EventArgs e)


{


Login(username.Text, password.Text);


}








Edit by moderator - NetProfit: Added < code>< /code> tags.