protected void FormView1_ItemInserting(object sender, FormViewInsertEventArgs e) { TextBox Email = (TextBox)FormView1.FindControl("TextBoxEmail"); string ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;" + "Data Source=D:\\Database.mdb"; OleDbConnection oConn = new OleDbConnection(ConnectionString); string strSQL = "Select Count(Email) as TheCount from Users where Email =? "; OleDbCommand cmd = new OleDbCommand(strSQL, oConn); cmd.Parameters.AddWithValue("", Email.Text); int Result = (int)cmd.ExecuteScalar(); if(Result > 0) { e.Cancel = true; Label Duplicate = (Label)FormView1.FindControl("lblDuplicate"); Duplicate.Text = "That email address is already in use"; } }reference: http://forums.asp.net/t/1116970.aspx
Saturday, July 30, 2011
Check for duplicate when inserting a recod ( formView)
Ex.
Labels:
asp.net
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment