Strange Problem: SQL Insert Statement Does Not Insert All The Fields Into Table From Asp.net C# Webpage

An insert statement was not inserting all the data into a table. Found it very strange as the other fields in the row were inserted. I ran SQL profiler and found that sql statement had all the fields in the insert statement but some of the fields were not inserted. Below is the sql statement which is created dyanmically by a asp.net C# class. The columns which are not inserted are 'totaltax' and 'totalamount' ...while the 'shipto_name' etc...were inserted.

there were not errors thrown. The sql from the code cannot be shown here as it is dynamically built referencing C# class files.


It works fine on another test database which uses the same dlls. The only difference i found was the difference in date formats..

@totalamount=1625.62,
@totaltax=125.62

are not inserted into the database.

Below is the statement copied from SQL profiler.

exec sp_executesql N'INSERT INTO salesorder
(billto_city, billto_country, billto_line1, billto_line2, billto_name,
billto_postalcode,
billto_stateorprovince, billto_telephone, contactid, CreatedOn,
customerid, customeridtype,
DeletionStateCode, discountamount,
discountpercentage, ModifiedOn, name, ordernumber,
pricelevelid, salesorderId, shipto_city, shipto_country,
shipto_line1, shipto_line2,
shipto_name, shipto_postalcode, shipto_stateorprovince,
shipto_telephone, StateCode, submitdate, totalamount,
totallineitemamount, totaltax
) VALUES
(@billto_city, @billto_country, @billto_line1, @billto_line2,
@billto_name, @billto_postalcode, @billto_stateorprovince,
@billto_telephone, @contactid, @CreatedOn, @customerid,
@customeridtype, @DeletionStateCode, @discountamount,
@discountpercentage,
@ModifiedOn, @name, @ordernumber, @pricelevelid, @salesorderId,
@shipto_city, @shipto_country, @shipto_line1, @shipto_line2,
@shipto_name,
@shipto_postalcode, @shipto_stateorprovince, @shipto_telephone,
@StateCode, @submitdate, @totalamount, @totallineitemamount,
@totaltax)',N'@billto_city nvarchar(8),
@billto_country nvarchar(13),@billto_line1 nvarchar(3),
@billto_line2 nvarchar(4),@billto_name nvarchar(15),
@billto_postalcode nvarchar(5),
@billto_stateorprovince nvarchar(8),
@billto_telephone nvarchar(3),@contactid
uniqueidentifier,@CreatedOn datetime,
@customerid uniqueidentifier,@customeridtype int,
@DeletionStateCode int,@discountamount
decimal(1,0),@discountpercentage decimal(1,0),
@ModifiedOn datetime,@name nvarchar(33),
@ordernumber nvarchar(18),@pricelevelid
uniqueidentifier,@salesorderId uniqueidentifier,
@shipto_city nvarchar(8),@shipto_country nvarchar(13),@shipto_line1
nvarchar(3),@shipto_line2 nvarchar(4),@shipto_name nvarchar(15),
@shipto_postalcode nvarchar(5),@shipto_stateorprovince
nvarchar(8),@shipto_telephone nvarchar(3),@StateCode int,
@submitdate datetime,@totalamount decimal(6,2),
@totallineitemamount decimal(6,2),
@totaltax decimal(5,2)',
@billto_city=N'New York',
@billto_country=N'United States',
@billto_line1=N'454',
@billto_line2=N'Road',
@billto_name=N'Hillary Clinton',
@billto_postalcode=N'10001',
@billto_stateorprovince=N'New York',
@billto_telephone=N'124',
@contactid='8DAFE298-3A25-42EE-B208-0B79DE653B61',
@CreatedOn=''2008-04-18 13:37:12:013'',
@customerid='8DAFE298-3A25-42EE-B208-0B79DE653B61',
@customeridtype=2,@DeletionStateCode=0,@discountamount=0,
@discountpercentage=0,
@ModifiedOn=''2008-04-18 13:37:12:013'',
@name=N'E-Commerce Order (Before billing)',
@ordernumber=N'BRKV-CC-OKRW5764YS',
@pricelevelid='B74DB28B-AA8F-DC11-B289-000423B63B71',
@salesorderId='9CD0E11A-5A6D-4584-BC3E-4292EBA6ED24',
@shipto_city=N'New York',
@shipto_country=N'United States',
@shipto_line1=N'454',
@shipto_line2=N'Road',
@shipto_name=N'Hillary Clinton',
@shipto_postalcode=N'10001',
@shipto_stateorprovince=N'New York',
@shipto_telephone=N'124',
@StateCode=0,
@submitdate=''2008-04-18 14:37:10:140'',
@totalamount=1625.62,
@totallineitemamount=1500.00,
@totaltax=125.62


 


thanks