Generating the DataTable from the XML file

unathi guma

7y2.2kWindows Forms

I got this code here and it's giving me errors.

public DataTable CreateDataTableXML(string XmlFile)

{

XmlDocument doc = new XmlDocument();

doc.Load(XmlFile);

try

{

Dt.TableName = GetTableName(XmlFile);

XmlNode NodoEstructura = doc.DocumentElement.ChildNodes.Cast.ToList()[0];

progressBar1.Maximum = NodoEstructura.ChildNodes.Count;

progressBar1.Value = 0;

foreach (XmlNode columna in NodoEstructura.ChildNodes)

{

Dt.Columns.Add(columna.Name, typeof(String));

Progress();

}

XmlNode Filas = doc.DocumentElement;

progressBar1.Maximum = Filas.ChildNodes.Count;

progressBar1.Value = 0;

foreach (XmlNode Fila in Filas.ChildNodes)

{

List Valores = Fila.ChildNodes.Cast().ToList().Select(x => x.InnerText).ToList();

Dt.Rows.Add(Valores.ToArray());

Progress();

}

catch (Exception ex)

{

}

return Dt;

}

9 Replies

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

Riddhi Valecha6y ago
Hello Team,
Same issue -
GetTableName(XmlFile); - Is not there.
Instead of xmlfile, can we put xmlstring ?
Laxmidhar Sahoo6y ago
Hey where define Dt
Riddhi Valecha6y ago
Dear Team,

I am also facing the same issue...

Converting xml output to datatable.

I have shared my xml output here...

My post link is -

Hello sir... Thank you for your reply on my post.
I have shared my xml string.
Please help me in converting it into datatable and display it on gridview.

My Post -
https://www.c-sharpcorner.com/Forums/web-api-convert-xml-output-to-datatable-and-display-data

Please help me out..
Rajanikant Hawaldar6y ago
https://www.codeproject.com/Questions/404384/How-to-convert-a-XMl-File-to-DataTable-using-Cshar
Laxmidhar Sahoo6y ago
just put any string like
Dt.TableName = "youtable";
Vivek Kumar7y ago
Hi,
Have a look to below links for your reference.

https://stackoverflow.com/questions/36339304/how-can-i-create-a-datatable-from-an-xml-file-in-c

https://social.msdn.microsoft.com/Forums/windows/en-US/630925d6-ae80-4370-a75b-85da83fc8ccf/how-fill-datatable-from-xml-file-in-c-windows-forms?forum=winformsdatacontrols
Salman Beg7y ago
Hey. You can put a breakpoint at catch block and check the error. Otherwise Check the GetTableName method also may be there some error exists.
Thanks.
Amit Gupta7y ago
What's the error? Do mention that!

DataTable class has a built-in function to read/write an XML file, you can use that.

Take a reference
https://stackoverflow.com/questions/4461123/how-to-read-xml-into-a-datatable

Good Luck!!
unathi guma7y ago
The error is on
Dt.TableName = GetTableName(XmlFile);

I dont see where GetTableName() is declared in the example. Please advise