Saturday, November 29, 2014

XML query dataset and to fill a datatable with this dataset

Hello


I convert ACCESS DB into XML.


I wrote this code:




string myXMLfile = Application.StartupPath + @"\Query_Table_Search.xml";
DataSet ds = new DataSet();
DataTable dt=new DataTable();
ds.ReadXml(myXMLfile);
dt= ds.Tables[0];

I get error: "Cannot find column 2" for dt.Rows[i][2].ToString() . I have just 1 row as a result and that is date of system. why?


This query has just one table.











No comments:

Post a Comment