Insert Command Fails When I Want To Insert Records In Data Table

On my site users can register using ASP Membership Create user Wizard control.

I am also using the wizard control to design a simple question and answer  form that logged in users have access to.

it has 2 questions including a text box for Q1 and  dropdown list for Q2.

I have a table in my database called "Players" which has 3 Columns

UserId Primary Key of type Unique Identifyer

PlayerName Type String

PlayerGenre Type Sting

 

On completing the wizard and clicking the finish button, I want the data to be inserted into the SQl express Players table.

I am having problems getting this to work and keep getting exceptions.

 Be very helpful if somebody could check the code and advise where the problem is??

 

 

<asp:Wizard ID="Wizard1" runat="server" BackColor="#F7F6F3"

BorderColor="#CCCCCC" BorderStyle="Solid" BorderWidth="1px"

DisplaySideBar="False" Font-Names="Verdana" Font-Size="0.8em" Height="354px"

onfinishbuttonclick="Wizard1_FinishButtonClick" Width="631px">

<SideBarTemplate>

<asp:DataList ID="SideBarList" runat="server">

<ItemTemplate>

<asp:LinkButton ID="SideBarButton" runat="server" BorderWidth="0px"

Font-Names="Verdana" ForeColor="White"></asp:LinkButton>

</ItemTemplate>

<SelectedItemStyle Font-Bold="True" />

</asp:DataList>

</SideBarTemplate>

<StepStyle BackColor="#669999" BorderWidth="0px" ForeColor="#5D7B9D" />

<NavigationStyle VerticalAlign="Top" />

<WizardSteps>

<asp:WizardStep runat="server">

<table class="style1">

<tr>

<td class="style4">

A<span class="style6">Player Name</span></td>

<td class="style3">

<asp:TextBox ID="PlayerName" runat="server"></asp:TextBox>

</td>

<td>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"

ControlToValidate="PlayerName" ErrorMessage="RequiredFieldValidator"></asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<td class="style5">

 

<td class="style3">

<asp:DropDownList ID="PlayerGenre" runat="server" Width="128px">

<asp:ListItem Value="-1">Select Genre</asp:ListItem>

<asp:ListItem>Male</asp:ListItem>

<asp:ListItem>Female</asp:ListItem>

</asp:DropDownList>

</td>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"

ControlToValidate="PlayerGenre" ErrorMessage="RequiredFieldValidator"></asp:RequiredFieldValidator>

</td>

 

</tr>

</table>

  Sql Data Source

<asp:SqlDataSource ID="InsertArtist1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" InsertCommand="INSERT INTO [Playerst] ([UserId], [PlayerName], [PlayerGenre]) VALUES (@UserId, @PlayerName, @PlayerGenre)"

 

ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>">

<InsertParameters>

<asp:Parameter Name="UserId" Type="Object" />

<asp:Parameter Name="PlayerName" Type="String" />

<asp:Parameter Name="PlayerGenre" Type="String" />

</InsertParameters>

 

 

</asp:SqlDataSource>

</asp:WizardStep>

 

 Event Handler

 

To match the answers to the user I get the UserId and insert this into the database to.protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e)

{

 SqlDataSource DataSource = (SqlDataSource)Wizard1.FindControl("InsertArtist1");

MembershipUser myUser = Membership.GetUser(this.User.Identity.Name);

Guid UserId = (Guid)myUser.ProviderUserKey;String Gender = ((DropDownList)Wizard1.FindControl("PlayerGenre")).SelectedValue;

DataSource.InsertParameters.Add("UserId", UserId.ToString());DataSource.InsertParameters.Add("PlayerGenre", Gender.ToString());

DataSource.Insert();

 

}