tags:

views:

22

answers:

0
Q: 

Insert a NULL Date field into a Strongly Typed Dataset without getting a System.InvalidCastException

System.Data.StrongTypingException("The value for column 'CS_REPLY_DATE' in table 'CSAA_STATUS' is DBNull."

I am using an Xmldataset .XSD connecting SQL Server 2005 tables, the dates I want to null out upon Initial insertion of a row into the table. The table date field allow nulls. I am using a strongly typed xsd table row and the autogenerated xsd tablespecificadaper.insert(field, field, field, etc)

But when i get to the tableadaper.insert I get the above. Is there any way to get around this PAINFUL problem without using a basic sqlstmt and dataadaper, and command text.

related questions

cannot insert DBNULL value into sql server
How can DBNull not equal DBNull
Avoiding NULL object in HQL Query where clause
System.DBNull with data contract name not expected in WCF
DBnull in Linq query causing problems
How can I include DBNull as a value in my strongly typed dataset?
How do I handle a DBNull DateTime field coming from the SQL Server?
Why isn't my DbNull a singleton when I deserialise it using XmlSerialiser?
Question about Type Comparison ASP.NET and DBNull
Powershell and SQL parameters. If empty string, pass DBNull
LINQ to Dataset DBNULL problem / null reference exception
How do I set a field to DBNull in Entity Framework
SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
Dataset field DBNull -> int?
Problem inserting string or NULL into SQL Server database
How do I handle Conversion from type 'DBNull' to type 'String' is not valid
How do I handle a DBNull to Boolean conversion in my XSD DataSet?
What is the best practice for handling null int/char from a SQL Database?
Not-Null constraints in POCO Objects
handling dbnull data in vb.net
Most efficient way to check for DBNull and then assign to a variable?
C# ADO.NET: nulls and DbNull -- is there more efficient syntax?
.NET DBNull vs Nothing across all variable types?
(any == System.DBNull.Value) vs (any is System.DBNull)
C# Database Access: DBNull vs null