UpdateParameters Collection Usage

If you have received any of the following error message regarding the ObjectDataSourceView.ConvertType:

1. When receiving dates from browsers that are set with different culture settings than your server:
   Cannot convert value of parameter 'OrderDate' from 'System.String'
2. When the user leave a textbox empty when a numeric value was supposed to be entered:
   [FormatException: Input string was not in a correct format.]

Then set the ConvertNullToDBNull property of the DataSource control to true and add an UpdateParameters collection. In this sample I explicity cast the updated values to their appropriate types:

    <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>
    

click here to view the type casting error of this page without the UpdateParamertes

Alfreds Futterkiste Ana Trujillo Emparedados y helados Antonio Moreno Taquería Around the Horn Berglunds snabbköp Blauer See Delikatessen Blondesddsl père et fils Bólido Comidas preparadas Bon app' Bottom-Dollar Markets B's Beverages Cactus Comidas para llevar Centro comercial Moctezuma Chop-suey Chinese Comércio Mineiro Consolidated Holdings Drachenblut Delikatessen Du monde entier Eastern Connection Ernst Handel Familia Arquibaldo FISSA Fabrica Inter. Salchichas S.A. Folies gourmandes Folk och fä HB Frankenversand France restauration Franchi S.p.A. Furia Bacalhau e Frutos do Mar Galería del gastrónomo Godos Cocina Típica Gourmet Lanchonetes Great Lakes Food Market GROSELLA-Restaurante Hanari Carnes HILARION-Abastos Hungry Coyote Import Store Hungry Owl All-Night Grocers Island Trading Königlich Essen La corne d'abondance La maison d'Asie Laughing Bacchus Wine Cellars Lazy K Kountry Store Lehmanns Marktstand Let's Stop N Shop LILA-Supermercado LINO-Delicateses Lonesome Pine Restaurant Magazzini Alimentari Riuniti Maison Dewey Mère Paillarde Morgenstern Gesundkost North/South Océano Atlántico Ltda. Old World Delicatessen Ottilies Käseladen Paris spécialités Pericles Comidas clásicas Piccolo und mehr Princesa Isabel Vinhos Que Delícia Queen Cozinha QUICK-Stop Rancho grande Rattlesnake Canyon Grocery Reggiani Caseifici Ricardo Adocicados Richter Supermarkt Romero y tomillo Santé Gourmet Save-a-lot Markets Seven Seas Imports Simons bistro Spécialités du monde Split Rail Beer & Ale Suprêmes délices The Big Cheese The Cracker Box Toms Spezialitäten Tortuga Restaurante Tradição Hipermercados Trail's Head Gourmet Provisioners Vaffeljernet Victuailles en stock Vins et alcools Chevalier Die Wandernde Kuh Wartian Herkku Wellington Importadora White Clover Markets Wilman Kala Wolski Zajazd
ObjectDataSource Class Documentation

Using Parameters with the ObjectDataSource Control documentation on the MSDN