DataTable and NULL values

's Computer Specifications

Is there a property/method to set the DataTable to allow
System.Convert.DBNull (for certain fields) when inserting
a record?

NOTE: There is only 1 table in this dataset with NO
relations or constraints.

By allowing this, I can test If MyTable("Field") Is
System.Convert.DBNull Then ...

Peter

's Computer Specifications

Set the AllowDBNull property of the DataColumn to True

Stephen

"Peter" <(E-Mail Removed)> wrote in message
news:049301c34b19$efc61e70$(E-Mail Removed)...
> Is there a property/method to set the DataTable to allow
> System.Convert.DBNull (for certain fields) when inserting
> a record?
>
> NOTE: There is only 1 table in this dataset with NO
> relations or constraints.
>
> By allowing this, I can test If MyTable("Field") Is
> System.Convert.DBNull Then ...
>
> Peter
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display queried records with Null values (null recordcount)	Mishanya	Microsoft Access Getting Started	6	25th Jan 2009 06:53 PM
NULL Values from DataTable assigned to Textbox creates error	MU	Microsoft ASP .NET	3	15th Jan 2009 07:46 PM
Empty text values aren't null or zero-length, but 2-byte null (\x0000)	Mark Steward	Microsoft Access	2	21st Jan 2006 02:03 PM
Datatable retrieving Null values - I'm stuck !	=?Utf-8?B?U3R1YXJ0?=	Microsoft ASP .NET	2	16th Feb 2005 06:45 AM
Adding a Calculated column to a DataTable: How to handle w/ null values	Sam	Microsoft Dot NET Framework	1	8th Apr 2004 09:06 PM