Ok,
This is what I have at the moment:
SQL query:
INSERT INTO PSD (CustomerId, CheckNumber, ItemId, FrankingCharge, ServiceCharge, Name, AccountYear, LastModified, DateCreated, ServiceYear, FrankingYear, ItemPrice, Quantity, CheckTotal) VALUES (@CustomerID, @CheckNumber, @ItemID, CAST(@FrankingCharge AS Money), CAST(@ServiceCharge AS Money), @Name, @AccountYear, @LastModified, @DateCreated, @ServiceYear, @FrankingYear, CAST(@ItemPrice AS Money), @Quantity, CAST(@CheckTotal AS Money))
On my HTML page I have a Dropdown list that lists my customers. I also have a table where they can enter information. At this stage it is a one line table which I want to make multiple lines. This is where I am stuck at the moment, because I can't enter Null's into the table and I need to figure out how to skip the text boxes or rows in the table that do not have any information in them.
Here is the HTML code:
Private Sub InsertRecord(ByVal sender As System.Object, ByVal e As System.EventArgs)
Insert.Insert()
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<script language="javascript" type="text/javascript">
<!--
function TABLE1_onclick() {
}
// -->
</script>
</head>
<body>
<form id="form1" runat="server">
<div align="center">
<asp:SqlDataSource ID="Insert" runat="server" ConnectionString="<%$ ConnectionStrings:InsertConnection %>"
InsertCommand="INSERT INTO PSD (CustomerId, CheckNumber, ItemId, FrankingCharge, ServiceCharge, Name, AccountYear, LastModified, DateCreated, ServiceYear, FrankingYear, ItemPrice, Quantity, CheckTotal) VALUES (@CustomerID, @CheckNumber, @ItemID, CAST(@FrankingCharge AS Money), CAST(@ServiceCharge AS Money), @Name, @AccountYear, @LastModified, @DateCreated, @ServiceYear, @FrankingYear, CAST(@ItemPrice AS Money), @Quantity, CAST(@CheckTotal AS Money))"
SelectCommand="SELECT PSD.* FROM [user].PSD"
UpdateCommand="UPDATE PSD SET CustomerId = @CustomerID, CheckNumber = @CheckNumber, ItemId = @ItemID, FrankingCharge = Convert(Money, @FrankingCharge), ServiceCharge = Convert(Money, @ServiceCharge), Name = @Name, AccountYear = @AccountYear, LastModified = @LastModified, DateCreated = @DateCreated, ServiceYear = @ServiceYear, FrankingYear = @FrankingYear, ItemPrice = Convert(Money, @ItemPrice), Quantity = @Quantity">
<UpdateParameters>
<asp:Parameter Name="CustomerID" />
<asp:Parameter Name="CheckNumber" />
<asp:Parameter Name="ItemID" />
<asp:Parameter Name="FrankingCharge" />
<asp:Parameter Name="ServiceCharge" />
<asp:Parameter Name="Name" />
<asp:Parameter Name="AccountYear" />
<asp:Parameter Name="LastModified" />
<asp:Parameter Name="DateCreated" />
<asp:Parameter Name="ServiceYear" />
<asp:Parameter Name="FrankingYear" />
<asp:Parameter Name="ItemPrice" />
<asp:Parameter Name="Quantity" />
</UpdateParameters>
<InsertParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="CustomerID" PropertyName="SelectedValue" />
<asp:FormParameter Name="CheckNumber" formfield="CheckNumber"/>
<asp:FormParameter Name="ItemID" formfield="ItemDropdown"/>
<asp:FormParameter Name="FrankingCharge" Formfield="FrankingBox"/>
<asp:FormParameter Name="ServiceCharge" formfield="ServiceBox"/>
<asp:FormParameter Name="Name" formfield="CNameBox"/>
<asp:FormParameter Name="AccountYear" FormField="AccountBox" />
<asp:ControlParameter ControlID="TimeLabel" Name="LastModified" PropertyName="Text" />
<asp:ControlParameter ControlID="TimeLabel" Name="DateCreated" PropertyName="Text" />
<asp:FormParameter Name="ServiceYear" FormField="SyearBox"/>
<asp:FormParameter Name="FrankingYear" FormField="FyearBox"/>
<asp:FormParameter Name="ItemPrice" FormField="ItemPBox"/>
<asp:FormParameter Name="Quantity" FormField="QBox"/>
<asp:FormParameter Name="CheckTotal" FormField="CTotalBox"/>
</InsertParameters>
</asp:SqlDataSource>
I would greatly appreciate the help.
Thanks a bunch!!
41
