XML element not displaying for empty values

Question

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?

Sourabh Somani · Answer

Then do this for(int i=0;i { if(ID[i]==Null) { ID[i] = Set Some Value; } }

Vignesh Kumar · Answer

I have already tried and it doesn't work.

Sourabh Somani · Answer

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

Nishant Mittal · Answer

Hi try below link http://csharp.net-informations.com/xml/xml-to-database.htm