UpdateParameters Collection Usage
To see this demo, set your browser->Tools->Internet Options->Languages preference to something other than en-us (English United States).
This would cause the date format to display differently than my data server and would cause a type casting error.
I have commented out the following section out of the code to cause the error to happen.
<UpdateParameters>
<asp:Parameter Name="OrderDate" Type="DateTime" />
<asp:Parameter Name="ShipName" Type="String" />
<asp:Parameter Name="Freight" Type="String" />
<asp:Parameter Name="OrderID" Type="Int32" />
</UpdateParameters>
| Edit | 10643 |
8/25/1997
| 29.4600 | Alfreds Futterkiste |
| Edit | 10692 |
10/3/1997
| 61.0200 | Alfred's Futterkiste |
| Edit | 10702 |
10/13/1997
| 23.9400 | Alfred's Futterkiste |
| Edit | 10835 |
1/15/1998
| 69.5300 | Alfred's Futterkiste |
| Edit | 10952 |
3/16/1998
| 40.4200 | Alfred's Futterkiste |
| Edit | 11011 |
4/9/1998
| 1.2100 | Alfred's Futterkiste |