Generate columns from a table column having XML string

In a table column i've data as given below

Record- 001

Record- 002

Record- 003

Record- 004

Record- 005

Record- 006

so i want to generate six columns into new table from this column data given above. this is single column data of a row. Each row hold this kind of column of xml string.

Columns may be dynamic i.e. may be other 1 or 2 or .....

INSGRP1 INSGRP2 INSGRP3 INSGRP4 INSGRP5 INSGRP6

Record- 001 Record- 002 Record- 003 Record- 004 Record- 005 Record- 006

What kind of table you want to create?

Database table?

You wan to show data in tabular format in the UI?

Your application is Web Application or Windows Application?

Following it the logic of getting columname and value from the XML string you share.

You can change it and use it as per your requirement.

var xmlString = "1Record-0012Record-0023Record-0034Record-0045Record-0056Record-006";
var xmlDoc = new XmlDocument();
xmlDoc.LoadXml(xmlString);
var rootNode = xmlDoc.DocumentElement;
var columnPrefix = "INSGRP";
var count = 1;
foreach (XmlNode node in rootNode.SelectNodes("item/column[@name=\"MIN(INSGRP)\"]"))
{
Console.WriteLine("Column Name : " + columnPrefix + count);
Console.WriteLine("Column Value: " + node.InnerText);
count++;
}
Console.WriteLine("Done...");
Console.ReadKey();

1 Reply

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

Chetan Ranpariya9y ago
What kind of table you want to create?
Database table?
You wan to show data in tabular format in the UI?

Your application is Web Application or Windows Application?

Following it the logic of getting columname and value from the XML string you share.
You can change it and use it as per your requirement.
var xmlString = "1Record-0012Record-0023Record-0034Record-0045Record-0056Record-006";

            var xmlDoc = new XmlDocument();

            xmlDoc.LoadXml(xmlString);

            var rootNode = xmlDoc.DocumentElement;
            var columnPrefix = "INSGRP";
            var count = 1;

            foreach (XmlNode node in rootNode.SelectNodes("item/column[@name=\"MIN(INSGRP)\"]"))
            {
                Console.WriteLine("Column Name : " + columnPrefix + count);
                Console.WriteLine("Column Value: " + node.InnerText);
                count++;
            }
            Console.WriteLine("Done...");
            Console.ReadKey();