Hi everybody,

I could not figure out a proper way to set InsertCommand for the SQLDataSource used by the FormView in the code and where (which method in the page) I can do this.

Right now I have it in the

protected void ddlPersonType_SelectedIndexChanged(object sender, EventArgs e)
    {         
        DropDownList ddl = (DropDownList)sender;
        this.PersonType = ddl.SelectedValue;

        string SelectedItem = ddl.SelectedItem.ToString();
        switch (SelectedItem)
        {
            case "Special Friend":
                this.PeopleFriendsDataSource.InsertCommand =
                @"BEGIN TRAN 
                  INSERT INTO Registration 
                  (FirstName, MiddleName, LastName, Gender, 
                   DOB, Address1, Address2, City, State, Zip, 
                   Email, ScreenName, HomePhone, CellPhone, 
                   Comment, UserName, Pwd, 
                   School, Grade, MedicalConcerns, Medications, NonActivities, 
...

and I'm getting an error that the form doesn't have InsertCommand specified.

How and where can I set it?

Thanks a million in advance.