Read [for xml auto, elements] into DataTable in ADO.NET
- by ihorko
Hello All!
I have MS SQL Server stored procedure that returns XML (it uses SELECT with for xml auto, elements)
I tried read it into DataTable:
DataTable retTable = new DataTable();
SqlCommand comm = new SqlCommand("exec MySP", connection);
SqlDataAdapter da = new SqlDataAdapter(comm);
…