PC Review


Reply
Thread Tools Rate Thread

Table Adapters ADO 2.0

 
 
Microsoft Newsserver
Guest
Posts: n/a
 
      23rd Jun 2008
I am using a table in SQL which has a Date field which allows Nulls. I have
created a table adapter in order to manipulate this table. So far so good.

This field is 'RequiredByDate'.


If I create an Insert method in my table adapter and pass the function a
null, when I run that function, it fails and tells me that



throw new global::System.Data.StrongTypingException("The value for column
\'RequiredByDate\' in table \'tblIssue\' is DBNull.", e);

There is a member function which allows you to set the RequriedByDate's
column's base type to DBNull, but this seems to conflict with the property
for this column,

In Short. How do I set a value to Null using a table adapter function
without generating these exceptions. ?


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Typed datasets and table table adapters components not showing inToolbox bz Microsoft Dot NET 3 10th Apr 2008 02:13 AM
Typed datasets and table table adapters components not showing inToolbox bz Microsoft Dot NET Framework 0 9th Mar 2008 12:03 AM
Table adapters vs. Data adapters Chas Microsoft VB .NET 1 23rd May 2007 06:04 AM
Import text file to access db table (OleDB, ADO, ADO.NET) Max Microsoft ADO .NET 1 9th Dec 2003 07:28 PM
Import text file to access db table (OleDB, ADO, ADO.NET) Max Microsoft ADO .NET 0 6th Dec 2003 05:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:08 PM.