Assuming that the underlying table permits null values in field5, code that constructs
a SQL "insert" statement specifying the list of columns it can see will end up adding
a null value for the column. I don't see why it's a problem to have no value for the
column in the XML.
The only time the
MAIL PROTECTED] On Behalf Of Vitesh Aggarwal,
Noida
Sent: Thursday, August 26, 2004 9:38 AM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Null Fields in DataSet.GetXML()
Thanks Amit!
Actually I am not writing the XML to a file..
What I am doing is converting the dataset into a string using : GetXML(
To: [EMAIL PROTECTED]
Sent: Thu, 26 Aug 2004 18:47:13 +0530
Subject: [ADVANCED-DOTNET] Null Fields in DataSet.GetXML()
> I am running the code below to generate XML from a data table. But some
> fields in the data table are Null for every record. Suppose field5 has a
> null database va
Message-
From: Unmoderated discussion of advanced .NET topics.
[mailto:[EMAIL PROTECTED] On Behalf Of Amit Sinha
Sent: Thursday, August 26, 2004 6:54 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] Null Fields in DataSet.GetXML()
Vitesh,
try this
objDs.WriteXml("C:\tes
On Thu, 26 Aug 2004 18:47:13 +0530, Vitesh Aggarwal, Noida
<[EMAIL PROTECTED]> wrote:
>I am running the code below to generate XML from a data table. But some
>fields in the data table are Null for every record. Suppose field5 has a
>null database value. I would expect to see:
>
> or
>
>but inste
Behalf Of Vitesh
Aggarwal, Noida
Sent: Thursday, August 26, 2004 9:17 AM
To: [EMAIL PROTECTED]
Subject: [ADVANCED-DOTNET] Null Fields in DataSet.GetXML()
I am running the code below to generate XML from a data table. But some
fields in the data table are Null for every record. Suppose field5
I am running the code below to generate XML from a data table. But some
fields in the data table are Null for every record. Suppose field5 has a
null database value. I would expect to see:
or
but instead it doesn't even show the field at all for those records where
field5 is Null! Instead it ju
