Check data

Question

How to check textbox value is already exist or not with Entity Framework? Can anybody help me. Thanks a lot :-)

Asp.Net Hein · Answer

I want entity framework!! Not by layering!!!

Dipankar Biswas · Answer

hi try it.. public void EmailCheck() { string constring = ConfigurationManager.ConnectionStrings[ConnData].ConnectionString; SqlConnection con = new SqlConnection(constring); SqlCommand cmd = new SqlCommand(Select * from EmailSignUp where EmailId= @EmailId con); cmd.Parameters.AddWithValue(@EmailId this.txtEmail.Text); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if (dr.HasRows == true) { MessageBox.Show(EmailId =  + dr[5].ToString() +  Already exist); txtEmail.Clear(); break; } } } thanks...