Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old June 26th, 2006, 05:36 PM
Authorized User
Join Date: Feb 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Sqldatasource Inserting calculated values:

I am submitting this in both begginer and advance, 'cos I am not really sure where it really belongs:
Using sqldatasource, capturing values for labor costs per person per hour, parts charge etc. I set up text boxes for all the calculated values, and then named them as form control in my parameter specs.
<asp:QueryStringParameter DefaultValue="1" Name="subtotal1" QueryStringField="sub1" Type="Decimal" />
                    <asp:FormParameter DefaultValue="1" FormField="txtpeople" Name="labor" Type="Int32" />
                    <asp:FormParameter DefaultValue="1" FormField="txthrs" Name="laborhrs" Type="Decimal" />
                    <asp:FormParameter DefaultValue="1" FormField="txttotlab" Name="totlabchg" Type="Decimal" />
                    <asp:Parameter DefaultValue="300.00" Name="flatrate" Type="Decimal" />
                    <asp:FormParameter DefaultValue="1" FormField="txttotalcharge" Name="totalcharge"
                        Type="Decimal" />
                    <asp:FormParameter DefaultValue="1" FormField="txtgrandtotal" Name="grandtotal" Type="Decimal" />
I also tried the query string parameter:
<asp:QueryStringParameter DefaultValue="1" Name="totlabchg" QueryStringField="laborcharge"
                        Type="Decimal" />
the regular data is getting posted into the database but not the calculated fields, my store procedure works when I execute it in query analyzer. Please help....!!!

Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting values from other tables TheAndruu SQL Language 7 May 27th, 2007 10:47 AM
SqlDataSource On Inserting Event cyp7 ASP.NET 2.0 Professional 0 November 8th, 2006 04:07 PM
Insert calculated values using sqldatasource nuttylife2 ASP.NET 2.0 Basics 5 November 3rd, 2006 10:22 AM
inserting values sspr SQL Server 2000 2 February 15th, 2006 03:20 PM
inserting values error - Please help gtmm9 Classic ASP Databases 1 October 6th, 2003 11:43 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.