SqlDataSource1.Insert() Inserts Data Twice

Hi there,

I'm having a problem where the data taken from the textboxes is being inserted into a table twice. I looked online and someone on another forum was experiencing the same problem. His solution was making the "submitdsabledcontrols" attribute of the form false. That hasn't fixed the issue for me.

Below is my code. I'm still learning all this so this is just a test page, hence the wacky naming conventions.

When the button click calls Button1_Click, all it runs is "SqlDataSource1.Insert()"

Any ideas?

<%@ Page EnableEventValidation="false" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Default3.aspx.vb" Inherits="Default3" title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="mainContent" Runat="Server">

<form id="form1" submitdisabledcontrols=false>

<br />

<asp:Label ID="Label1" runat="server">Name</asp:Label>

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

<br />

<br />

<asp:Label ID="Label2" runat="server" Text="Label">Number</asp:Label>

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

<br />

<br />

<asp:Label ID="Label3" runat="server" Text="Label">Salary</asp:Label>

<asp:TextBox ID="SalaryTextBox" runat="server"></asp:TextBox>&nbsp;

<asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_click" />

</form>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pubsConnectionString1 %>" DeleteCommand="DELETE FROM [Table1] WHERE [TableID] = @original_TableID" InsertCommand="INSERT INTO [Table1] ([Name], [Number], [Salary]) VALUES (@Name, @Number, @Salary)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Table1]" UpdateCommand="UPDATE [Table1] SET [Name] = @Name, [Number] = @Number, [Salary] = @Salary WHERE [TableID] = @original_TableID">

<DeleteParameters>

<asp:Parameter Name="original_TableID" Type="Int32" />

</DeleteParameters>

<UpdateParameters>

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

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

<asp:Parameter Name="Salary" Type="Decimal" />

<asp:Parameter Name="original_TableID" Type="Int32" />

</UpdateParameters>



<InsertParameters>

<asp:ControlParameter Name="Name" Type="String" ControlID="NameTextBox" />

<asp:ControlParameter Name="Number" Type="String" ControlID="NumberTextBox" />

<asp:ControlParameter Name="Salary" Type="decimal" ControlID="SalaryTextBox" />

</InsertParameters>



</asp:SqlDataSource>

 

</asp:Content>