在ADO.NET中将[for xml auto，elements]读入DataTable(Read [for xml auto, elements] into DataTable in ADO.NET)

 我有MS SQL Server存储过程返回XML（它使用SELECT with for xml auto，elements ） 
 
 我尝试将其读入DataTable： 
 
            DataTable retTable = new DataTable();
            SqlCommand comm = new SqlCommand("exec MySP", connection);
            SqlDataAdapter da = new SqlDataAdapter(comm);
            connection.Open();
            da.Fill(retTable); 
 
 但retTable包含12行，SQL Server返回分隔的完整xml。 
 
 如何从DB读取XML到DataTable对象？ 谢谢！ 

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);
            connection.Open();
            da.Fill(retTable); 
 
but retTable contains 12 rows with separated full xml thar SQL Server returns.
 
How can I read that XML from DB into DataTable object? Thanks!

原文：https://stackoverflow.com/questions/4240126