webservice返回xml类型数据后绑定数据控件

1、webservice中的去数据方法

[WebMethod(Description = "读取数据")]
        public XmlDataDocument GetMenuData()
        {
            DataSet ds = new DataSet();
            //dt.TableName = "Column";
            SqlConnection conn = new SqlConnection(@"Data Source=WWW-A576DBF2758\SQL2005;AttachDbFilename=E:\gao\gaosc\gaosc\App_Data\gaosc.mdf;Integrated Security=True;");
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "select * from nz_Column";
            SqlDataAdapter sda=new SqlDataAdapter(cmd.CommandText,conn);
            sda.Fill(ds);
            XmlDataDocument xd = new XmlDataDocument(ds);
            return xd;
        }

2、绑定数据控件

XmlDataDocument xd = new XmlDataDocument();
        DataSet ds = new DataSet();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                WebApplication1.localhost1.GetData gd = new WebApplication1.localhost1.GetData();
                XmlNode xnode;
                System.Text.StringBuilder sbuilder;
                xnode = gd.GetMenuData();
                sbuilder = new System.Text.StringBuilder(xnode.OuterXml);
                xd.LoadXml(sbuilder.ToString());
                ds.ReadXml(new XmlNodeReader(xd));
                GridView1.DataSource = ds.Tables[0].DefaultView;
                GridView1.DataBind();
            }
        }