Check EmailID

Question

Hi.. I want to check EmailID in database when i am create new EmailID....

BangaruBabu Pureti · Answer

hi Let Me Explain [code] SqlConnection cn=new SqlConnection(Connection String); SqlDataAdapter da=new SqlDataAdater(select emailID from tableName where emailid='+txtemailID.Text+'cn) DataSet ds=new Dataset(); da.Fill(ds); if(ds.Tables[0].Rows.Count > 0) { Label1.Text=EmailID Exists; } else { Label1.Text=EmailID Not Exists; } [/code] I Think It will help you .Mark As Answered

Lalit M · Answer

You can check this URL http://forums.asp.net/t/1375014.aspx