Error by inserting a Date - DataSet

Carlos A.

Guest

Posts: n/a

08-26-2006

Hello all
(VB - SQL Server 2005)
I create a DataSet with the insert, update, fill... functions.
I have a problem when I try to insert a DateTime field only when it's empty,
I have the error message:
It's not possible to convert string to Date.
Normally when CustomerDate is not empty I convert the value with Cdate( ).
My question is: How can I insert a empty value in this field?

Thanks a lot

Thread Tools
Show Printable Version Email this Page

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
inserting a row in dataset	Abubakar	ASP .Net	1	01-06-2006 03:48 PM
inserting row in dataset PB	fh	ASP .Net	0	08-22-2005 02:24 PM
dataset.Databind error when dataset XML contains attributes...	ringo	ASP .Net Datagrid Control	0	08-18-2004 05:28 PM
Date, date date date....	Peter Grison	Java	10	05-30-2004 01:20 PM
Given a date, how to find the beginning date and ending date of that week	Matt	ASP .Net	1	11-08-2003 09:14 PM