Hi,
When executing following statement "select distinct Name from
CustomerParamet ers for xml auto"
- XmlReader reads "<customerparam eters name="Www.Mail. Generel" />"
- but SQL Query Manager returns "<CustomerParam eters
Name="Www.Mail. Generel"/><CustomerParam eters Name="Www.Mail. Updates"/>"
I'm using following to read the result returned from the SqlConnection
string result = "";
SqlCommand comm = conn.CreateComm and();
comm.CommandTyp e = CommandType.Tex t;
comm.CommandTex t = sql;
XmlReader reader = comm.ExecuteXml Reader();
reader.MoveToCo ntent();
result = reader.ReadOute rXml();
reader.Close();
comm.Dispose();
Why the difference ??
Thanks in advance
Soren