Use an SQL SELECT statement in the usual way:
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
using (SqlCommand com = new SqlCommand("SELECT * FROM myTable WHERE email=@EM", con))
{
com.Parameters.AddWithValue("@EM", myTextBoxWithEmailIn.Text);
}