XML element not displaying for empty values

Vignesh Kumar

10y1.3k.NET

Hi,

I am using an xml file to import into the database using the below code.

XmlDocument xmlDoc = new XmlDocument();

xmlDoc.Load(path + "Data.xml");

XmlNodeList nodeList = xmlDoc.DocumentElement.SelectNodes("/DocumentElement/Profile");

//read XML data and ID is one of the column

object[] ID = XDocument.Load(path + "Data.xml").Descendants("ID").Select(element => Element.Value).ToArray();

Now the ID element has null values and when I read them the rows with null values are omitted. How can I set empty string values for those null nodes?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sourabh Somani10y ago
Then do this

for(int i=0;i
{
if(ID[i]==Null)
{
ID[i] = "Set Some Value";
}
}
Vignesh Kumar10y ago
I have already tried and it doesn't work.

Sourabh Somani10y ago

You can use null-coalescing operator (?? Operator).
object[] ID = XDocument.Load(path + "Data.xml").Descendants("ID").Select(element => Element.Value).ToArray() ?? "EmptyID";

Nishant Mittal10y ago
Hi

try below link

http://csharp.net-informations.com/xml/xml-to-database.htm