I want to stop a formview from inserting if a record exists in the database (sql 2005).  If you look at my code below, how can I make the FV terminate if the record exists?  I can get the "Label2" to display if the record does exits, but can't stop the FV from inserting.

    protected void FormView1Duplicate(object sender, EventArgs e)
    {
        TextBox aTextBox = (TextBox)FormView1.FindControl("VarietalTypeTextBox");
        bool isExist = checkDulEmail(aTextBox.Text);
        if (isExist)
        {
            Label2.Text = "This varietal already exists in the database";
            //How do I stop the FV from Inserting

        }
        else
        {
            //Insert sql here

        }
    }

Use Eventargs e to cancel the event.

e.Cancel = true;

Subash

 Thanks,

I found this link: http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.formview.iteminserting.aspx

and what I had to do was change the commandarg to

(Object sender, FormViewInsertEventArgs e)

 and then put in e.Cancel = true inside the if clause.