Adding A New Row To SQL Table

Hi all,

I have a database setup with a few rows and i would like to allow a user to create a new row of data. After some googling, I've deduced that I need to somehow use an onclick command to perform an insert command. here is my code as of right now:

 protected void ItemAdd_Click(object sender, EventArgs e)

{int newnum = 4;int POnum = newnum ++;

 

 string Item = textbox3.Text.ToString();

string Quantity = textbox4.ToString();string Part = textbox5.ToString();

string Description = textbox6.Text.ToString();string Price = textbox7.Text.ToString();string UOM = textbox8.Text.ToString();

SqlDataSource2.InsertParameters.Clear();

SqlDataSource2.InsertParameters.Add("@Item", Item);SqlDataSource2.InsertParameters.Add("@Quantity", Quantity);

SqlDataSource2.InsertParameters.Add("@Part", Part);SqlDataSource2.InsertParameters.Add("@Description", Description);

SqlDataSource2.InsertParameters.Add("@Price", Price);SqlDataSource2.InsertParameters.Add("@UOM", UOM);

SqlDataSource1.InsertCommand = "insert into ItemMaster "+"values (12, @Item, @Quantity, @Part, @Description, @Price, @UOM)";

SqlDataSource2.Insert();

 

 

}

 

here's the aspx:

 

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="createpo.aspx.cs" Inherits="Subpgs_Purchasing_createpo" Title="Create A PO" %>

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

<table style="width: 600px; position: relative; top: 30px; height: 253px" cellpadding="10px">

<tr>

<td style="width: 180px; text-align: left;" rowspan="2">

Select Vendor<br />- or -<br /><asp:LinkButton ID="Linkbutton1" runat="server" OnClick="Linkbutton1_Click">Create Vendor</asp:LinkButton></td>

<td style="width: 100px" rowspan="2">

<asp:ListBox ID="ListBox2" runat="server" DataSourceID="SqlDataSource1" DataTextField="Name"

DataValueField="ID" OnSelectedIndexChanged="ListBox2_SelectedIndexChanged"></asp:ListBox><asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Vendor_info]"></asp:SqlDataSource>

</td>

<td style="width: 180px; text-align: left;">

Job/Req.S.O. No.</td>

<td style="width: 100px">

<asp:TextBox ID="Job" runat="server"></asp:TextBox></td>

</tr>

<tr>

 

<td style="width: 180px; text-align: left;">

Terms</td>

<td style="width: 100px">

<asp:TextBox ID="Terms" runat="server"></asp:TextBox></td>

</tr>

<tr>

<td style="width: 180px; text-align: left;">

F.O.B.</td>

<td style="width: 100px">

<asp:TextBox ID="FOB" runat="server"></asp:TextBox></td>

<td style="width: 180px; text-align: left;">

Ship To:<br />

Address:<br />

City / State / Zip:</td>

<td style="width: 100px">

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

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

<asp:TextBox ID="Ship3" runat="server"></asp:TextBox></td>

</tr>

</table>

 

<br />

<br />

<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Purchase_Orders.mdf;Integrated Security=True;User Instance=True;Context Connection=False"

ProviderName="System.Data.SqlClient" SelectCommand="SELECT [Item], [Quantity], [Part], [Description], [Price], [UOM], [Ammount], [PONumber] FROM [ItemMaster]" DeleteCommand="DELETE FROM [ItemMaster] WHERE [PONumber] = @PONumber" InsertCommand="INSERT INTO [ItemMaster] ([Item], [Quantity], [Part], [Description], [Price], [UOM], [Ammount], [PONumber]) VALUES (@Item, @Quantity, @Part, @Description, @Price, @UOM, @Ammount, @PONumber)" UpdateCommand="UPDATE [ItemMaster] SET [Item] = @Item, [Quantity] = @Quantity, [Part] = @Part, [Description] = @Description, [Price] = @Price, [UOM] = @UOM, [Ammount] = @Ammount WHERE [PONumber] = @PONumber">

<DeleteParameters>

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

</DeleteParameters>

<UpdateParameters>

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

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

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

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

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

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

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

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

</UpdateParameters>

<InsertParameters>

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

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

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

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

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

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

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

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

</InsertParameters>

</asp:SqlDataSource>

<br />

<table>

<tr>

<td>Item #</td>

<td><asp:TextBox ID="textbox3" runat=server></asp:TextBox></td>

<td>Quantity</td>

<td><asp:TextBox ID="textbox4" runat=server></asp:TextBox></td>

<td>Part Number</td><td><asp:TextBox ID="textbox5" runat=server></asp:TextBox></td>

</tr>

<tr>

<td>Description</td>

<td><asp:TextBox ID="textbox6" runat=server></asp:TextBox></td>

<td>Unit Price</td>

<td><asp:TextBox ID="textbox7" runat=server></asp:TextBox></td>

<td>Unit of Measure</td>

<td><asp:TextBox ID="textbox8" runat=server></asp:TextBox></td>

</tr>

<tr>

<td colspan="6" align="center"><asp:Button ID="ItemAdd" runat=server text="Add Item" OnClick="ItemAdd_Click" /></td>

</tr>

</table>

&nbsp;<br />

<br />

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="PONumber"

DataSourceID="SqlDataSource2">

<Columns>

<asp:CommandField ShowEditButton="True" />

<asp:BoundField DataField="Item" HeaderText="Item" SortExpression="Item" />

<asp:BoundField DataField="Quantity" HeaderText="Quantity" SortExpression="Quantity" />

<asp:BoundField DataField="Part" HeaderText="Part" SortExpression="Part" />

<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />

<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />

<asp:BoundField DataField="UOM" HeaderText="UOM" SortExpression="UOM" />

<asp:BoundField DataField="Ammount" HeaderText="Ammount" SortExpression="Ammount" />

<asp:BoundField DataField="PONumber" HeaderText="PONumber" ReadOnly="True" SortExpression="PONumber"

Visible="False" />

</Columns>

</asp:GridView>

<br />

<br />

<br />

<asp:Button ID="Button1" runat="server" Text="Submit Data" OnClick="Button1_Click" />&nbsp;<br />

<br />

<asp:Label ID="Label1" runat="server" Text="Please Verify Information below!" Visible="False"></asp:Label><br />

<br />

<table align="left">

<tr>

<td style="width: 200px; text-align: left;">

<asp:Label ID="Label4" runat="server" Text="Job/REQ.S.O. No." Visible="false"></asp:Label></td>

<td style="width: 200px; text-align: left;">

<asp:Label ID="Label5" runat="server"></asp:Label></td>

</tr>

<tr>

<td style="width: 200px; text-align: left;">

<asp:Label ID="Label7" runat="server" Text="Terms" Visible="false"></asp:Label></td>

<td style="width: 200px; text-align: left;">

<asp:Label ID="Label8" runat="server"></asp:Label></td>

</tr>

<tr>

<td style="width: 200px; text-align: left;">

<asp:Label ID="Label10" runat="server" Text="F.O.B." Visible="false"></asp:Label></td>

<td style="width: 200px; text-align: left;">

<asp:Label ID="Label11" runat="server"></asp:Label></td>

</tr>

</table>

 

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"

Height="50px" Visible="False" Width="260px" BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" CellSpacing="2" DataKeyNames="ID" ForeColor="Black">

<FooterStyle BackColor="#CCCCCC" />

<EditRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />

<RowStyle BackColor="White" />

<PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />

<Fields>

<asp:BoundField DataField="ID" HeaderText="ID" ReadOnly="True" SortExpression="ID" />

<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />

<asp:BoundField DataField="Street" HeaderText="Street" SortExpression="Street" />

<asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />

<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />

<asp:BoundField DataField="Zip" HeaderText="Zip" SortExpression="Zip" />

<asp:BoundField DataField="Telephone Number" HeaderText="Telephone Number" SortExpression="Telephone Number" />

<asp:BoundField DataField="Contact Information" HeaderText="Contact Information"

SortExpression="Contact Information" />

<asp:BoundField DataField="E-mail address" HeaderText="E-mail address" SortExpression="E-mail address" />

<asp:BoundField DataField="Fax Number" HeaderText="Fax Number" SortExpression="Fax Number" />

<asp:BoundField DataField="Comments" HeaderText="Comments" SortExpression="Comments" />

</Fields>

<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />

</asp:DetailsView>

<br />

<br />

<br />

<asp:Button ID="Button2" runat="server" Text="E-Mail PO" Visible="False" OnClick="Button2_Click" />

 

 

 

</asp:Content>

 

whenever I run this, I receive the following error and am not sure how to correct it:

 

System.Data.SqlClient.SqlException: Must declare the scalar variable "@Item".

 

If someone could please explain to me the process here of what is going ion it would be greatly appreciated.  My understanding is the @item is just a variable if you will so i'm not sure why its stating i need to declare it.

 

Thank you all!