Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsVB SyntaxEnterprise DevelopmentDatabase AccessControlsCOMWin APICrystal ReportDeploymentGeneralGeneral 2
Related Topics
VB.NET / ASP.NETMS SQL ServerMS AccessOther Database ProductsMore Topics ...

VB Forum / Database Access / October 2006



Tip: Looking for answers? Try searching our database.

Nulls

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vayse - 30 Oct 2006 00:43 GMT
Hi
Using VB.net 2005. In my xsd file, I set the Null value for a field called
Description to "X".However, when I fill the datatable from the access
database, if there is nothing in the Description field, it is still
System.DBNull.

1) What must I change in the XSD file to have the null values replaced with
X?

2) In code, how do I check if a field is null? Comparing to System.DBNull
isn't allowed.

Thanks
Vayse
Ralph - 30 Oct 2006 02:08 GMT
> Hi
> Using VB.net 2005. In my xsd file, I set the Null value for a field called
[quoted text clipped - 10 lines]
> Thanks
> Vayse

Wrong newsgroup. This newsgroup is populated by users of classic VB (vb6 and
below) and classic ADO (not ADO.Net which is an entirely different animal).

You need to post in a "dotNet" newsgroup, where there will be more people
who are familar with your product.

Try...
news://msnews.microsoft.com/
  microsoft.public.dotnet.languages.vb
  microsoft.public.dotnet.languages.vb.data
  microsoft.public.dotnet.framework.adonet
  microsoft.public.dotnet.framework.windowsforms.databinding
  microsoft.public.vsnet.general
  microsoft.public.vstudio.general

-ralph
Vayse - 30 Oct 2006 17:23 GMT
Oops!

>> Hi
>> Using VB.net 2005. In my xsd file, I set the Null value for a field
[quoted text clipped - 31 lines]
>
> -ralph
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.