ASP.Net: Insert null DateTime
- by Vinzcent
Hey
I'am using a SQLDatasource in combination with a Formview.
When I want to insert or update a DateTime that has no value, I always get an error.
How do you insert a DateTime null.
My SQLDataSource
<asp:SqlDataSource ID="sqldsDetailOrder" runat="server" ConnectionString="<%$ ConnectionStrings:csBookStore %>"
SelectCommand="SELECT 'AUTHOR' = tblAuthors.FIRSTNAME + ' ' + tblAuthors.LASTNAME, tblBooks.*, tblGenres.*, tblLanguages.*, tblOrders.* FROM tblAuthors INNER JOIN tblBooks ON tblAuthors.AUTHOR_ID = tblBooks.AUTHOR_ID INNER JOIN tblGenres ON tblBooks.GENRE_ID = tblGenres.GENRE_ID INNER JOIN tblLanguages ON tblBooks.LANG_ID = tblLanguages.LANG_ID INNER JOIN tblOrders ON tblBooks.BOOK_ID = tblOrders.BOOK_ID WHERE tblOrders.ID = @ID"
DeleteCommand="DELETE FROM [tblOrders] WHERE [ID] = @ID"
InsertCommand="INSERT INTO [tblOrders] ([NAME], [ADDRESS], [CITY], [PC], [DATE], [BOOK_ID], [COUNT], [AMOUNT], [DELIVERED], [DDATE], [PAID], [PDATE]) VALUES (@NAME, @ADDRESS, @CITY, @PC, @DATE, @BOOK_ID, @COUNT, @AMOUNT, @DELIVERED, @DDATE, @PAID, @PDATE)"
UpdateCommand="UPDATE [tblOrders] SET [NAME] = @NAME, [ADDRESS] = @ADDRESS, [CITY] = @CITY, [PC] = @PC, [DATE] = @DATE, [BOOK_ID] = @BOOK_ID, [COUNT] = @COUNT, [AMOUNT] = @AMOUNT, [DELIVERED] = @DELIVERED, [DDATE] = @DDATE, [PAID] = @PAID, [PDATE] = @PDATE WHERE [ID] = @ID">
<SelectParameters>
<asp:ControlParameter ControlID="gvOrdersAdmin" Name="ID"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="NAME" Type="String" />
<asp:Parameter Name="ADDRESS" Type="String" />
<asp:Parameter Name="CITY" Type="String" />
<asp:Parameter Name="PC" Type="String" />
<asp:Parameter DbType="DateTime" Name="DATE" />
<asp:Parameter Name="BOOK_ID" Type="Int32" />
<asp:Parameter Name="COUNT" Type="Int32" />
<asp:Parameter Name="AMOUNT" Type="Decimal" />
<asp:Parameter Name="DELIVERED" Type="Boolean" />
<asp:Parameter DbType="DateTime" Name="DDATE" />
<asp:Parameter Name="PAID" Type="Boolean" />
<asp:Parameter DbType="DateTime" Name="PDATE" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="NAME" Type="String" />
<asp:Parameter Name="ADDRESS" Type="String" />
<asp:Parameter Name="CITY" Type="String" />
<asp:Parameter Name="PC" Type="String" />
<asp:Parameter DbType="DateTime" Name="DATE" />
<asp:Parameter Name="BOOK_ID" Type="Int32" />
<asp:Parameter Name="COUNT" Type="Int32" />
<asp:Parameter Name="AMOUNT" Type="Decimal" />
<asp:Parameter Name="DELIVERED" Type="Boolean" />
<asp:Parameter DbType="DateTime?" Name="DDATE" />
<asp:Parameter Name="PAID" Type="Boolean" />
<asp:Parameter DbType="DateTime" Name="PDATE" />
</InsertParameters>
</asp:SqlDataSource>
Thanks Vincent
