Use ExecuteScalar to run something like this:
using (SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM MyTable WHERE EmailColumn=@EM", con)
{
cmd.Parameters.AddWithValue("@EM", emailTheUserTyped);
int count = (int) cmd.ExecuteScalar();
if (count != 0)
{
}
}