I'm thinking I'll change my approach and would use SP instead. But still the answer would be nice to know.

>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.