Hi,
When executing following statement "select distinct Name from
CustomerParameters for xml auto"
- XmlReader reads "<customerparameters name="Www.Mail.Generel" />"
- but SQL Query Manager returns "<CustomerParameters
Name="Www.Mail.Generel"/><CustomerParameters Name="Www.Mail.Updates"/>"
I'm using following to read the result returned from the SqlConnection
string result = "";
SqlCommand comm = conn.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = sql;
XmlReader reader = comm.ExecuteXmlReader();
reader.MoveToContent();
result = reader.ReadOuterXml();
reader.Close();
comm.Dispose();
Why the difference ??
Thanks in advance
Soren