XMLDOCUMENT Web服务返回XMLNODE [英] XMLDOCUMENT Web Service Returns XMLNODE

问题描述

我的XMLDOCUMENT网络服务返回XMLNODE

以下是我的方法

my XMLDOCUMENT web service return XMLNODE
below is my method

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Xml)]
public XmlDocument SearchBySpot(string spot)
{
    XmlDocument doc = new XmlDocument();
    try {
        DataTable result = new DataTable();
        result.TableName = "Location";
        string con = "myconnstring";
        using (SqlConnection connection = new SqlConnection(con))
        {

            SqlCommand cmd = new SqlCommand("GetByspot", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter parameter = new SqlParameter("@spot", spot);
            cmd.Parameters.Add(parameter);
            connection.Open();
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            SqlDataReader reader = cmd.ExecuteReader();
            result.Load(reader);



            DataSet ds = new DataSet();
            adapter.Fill(ds, "Location");
            string strXML = ds.GetXml();

            doc.LoadXml(strXML);



            connection.Close();



        }

    }
    catch (Exception ex)
    {

    }
    return doc;
}

推荐答案

这篇关于XMLDOCUMENT Web服务返回XMLNODE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！