C# DataSet.GetXml方法代码示例

 /// <summary>
 /// Loads the bread crumbs.
 /// </summary>
 private void LoadBreadCrumbs()
 {
     breadCrumbs = Store.Caching.CategoryCache.FetchCategoryBreadCrumbs(categoryId);
       xmlDataSource.EnableCaching = false;
       RewriteService.AddRewriteNameSpaceForXslt(xmlDataSource);
       xmlDataSource.Data = breadCrumbs.GetXml();
 }

        protected string getCountryInXml()
        {
            dbManager = new DBConnection();

            try
            {
                SqlCommand command = new SqlCommand();

                command.Connection = dbManager.Connection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "[dbo].[get_country_list]";

                XmlReader reader = command.ExecuteXmlReader();

                DataSet ds = new DataSet();
                ds.ReadXml(reader);

                return ds.GetXml();
            }

            finally
            {
                dbManager.Close();
            }
        }

        protected string GetDocketsForUserIdInXML(string userId)
        {
            dbManager = new DBConnection();

            try
            {
                SqlCommand command = new SqlCommand();

                command.Connection = dbManager.Connection;
                command.CommandType = CommandType.StoredProcedure;
                command.CommandText = "[dbo].[get_dockets_for_user]";

                command.Parameters.AddWithValue("@user_id", userId);

                XmlReader reader = command.ExecuteXmlReader();

                DataSet ds = new DataSet();
                ds.ReadXml(reader);

                return ds.GetXml();
            }
            finally
            {
                dbManager.Close();
            }
        }

 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         string sql = "";
         string strId = Request.QueryString["id"];
         if (strId != null && strId != "undefined")
         {
             if (strId != "All")
             {
                 strId = strId.Replace(",", "','");
                 sql = @"SELECT Id, ItemSKU, ItemName FROM Goods WHERE Id IN ('" + strId + "')";
             }
             else
             {
                 sql = @"SELECT Id, ItemSKU, ItemName FROM Goods";
             }
             DataSet ds = new DataSet();
             DataTable dt = db.RunTable<OrderType>(sql);
             dt.DefaultView.Sort = "Id asc";
             ds.Tables.Add(dt.DefaultView.ToTable());
             string xml = ds.GetXml();
             Utilities.ResponseXml(this, ref xml, false);
         }
     }
 }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                string sql = "";
                string Id = Request.QueryString["Id"];
                if (Id != null)
                {
                    OrderPrintRecordType oprt = OrderPrintRecordType.findById(cvt.ToInt(Id));
                    if (oprt != null)
                    {
                        sql = @"select (select COUNT(1) from PackageGoods where PackageGoods.PackageNo=p.PackageNo ) as GCount,p.PackageNo,o.TxnId,o.UserNameForm,o.OrderNo,o.OrderAmount,o.OrderCurrencyCode,o.OrderForm,o.OrderNote,p.LogisticsMode,
            pg.Sku,pg.ItemQty,o.NowOrderType,b.*,g.ItemName
            from Package p
            left join Orders o on p.OrderID=o.Id
            left join BuyerAddress b on o.AddressId=b.Id
            left join PackageGoods pg on p.PackageNo=pg.PackageNo
            left join Goods g on pg.Sku=g.ItemSku
            where o.Id in (" + oprt.OrderIds + ") and p.PackageStatus='未发货'";
                        DataSet ds = new DataSet();
                        DataTable dt = db.RunTable<OrderType>(sql);
                        dt.DefaultView.Sort = "GCount,PackageNo asc";
                        ds.Tables.Add(dt.DefaultView.ToTable());
                        string xml = ds.GetXml();
                        Utilities.ResponseXml(this, ref xml, false);
                    }
                }

            }
        }

        public static string displayNpt(List<string> _arr)
        {
            DataTable dummy = new DataTable();
            dummy.Columns.Add("Task Name");
            dummy.Columns.Add("Status");

            SystemObjects.OPT _opt = new SystemObjects.OPT();

            _opt.TeamID = Convert.ToInt32(_arr[0].ToString());
            DataSet ds = new DataSet();
            try
            {
                dummy.Merge(_opt.DisplayNptTask());
                if (dummy.Rows.Count < 1)
                {
                    dummy.Rows.Add();
                }
                ds.Tables.Add(dummy);
            }
            catch (Exception ex)
            {

            }
            return ds.GetXml();
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            string connStr = @"Data Source=Talha-PC\SQLExpress;Initial Catalog=LocalTestDB;User Id=talha;Password=talha123;Trusted_Connection=True;";
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                string sql = "Select MenuID, Text,Description, ParentID from Menu";
                SqlDataAdapter da = new SqlDataAdapter(sql, conn);
                da.Fill(ds);
                da.Dispose();
            }
            ds.DataSetName = "Menus";
            ds.Tables[0].TableName = "Menu";
            DataRelation relation = new DataRelation("ParentChild",
             ds.Tables["Menu"].Columns["MenuID"],
             ds.Tables["Menu"].Columns["ParentID"], true);

            relation.Nested = true;
            ds.Relations.Add(relation);

            XmlDataSource1.Data = ds.GetXml();

            if (Request.Params["Sel"] != null)
                Page.Controls.Add(new System.Web.UI.LiteralControl("You selected " + Request.Params["Sel"]));
        }

        public static string DateDisplay(Int32 teamid)
        {
            DateTime datestart, dateend;
            SystemObjects.TableF _tablef = new SystemObjects.TableF();
            _tablef.TeamID = teamid;
            DataSet ds = new DataSet();
            try
            {
                DataTable dt = new DataTable();
                dt = _tablef.displayRatingsDate();
                DataTable dtdate = new DataTable();
                dtdate.Columns.Add("Dates");
                dtdate.Rows.Add("Please select Month - Year...");
                datestart = Convert.ToDateTime(dt.Rows[0]["RateDateMin"].ToString());
                dateend = Convert.ToDateTime(dt.Rows[0]["RateDateMax"].ToString());
                while (datestart <= dateend)
                {
                    DateTime datestart_ = Convert.ToDateTime(datestart.Month.ToString() + "/01/" + datestart.Year.ToString());
                    dtdate.Rows.Add(String.Format("{0:MMMM - yyyy}", datestart_));
                    datestart = datestart.AddMonths(1);
                }
                ds.Tables.Add(dtdate);
            }
            catch (Exception ex)
            {

            }

            return ds.GetXml();
        }

        static void Main(string[] args)
        {
            
            DataTable table1 = new DataTable("Patients");

            table1.Columns.Add("Name");
            table1.Columns.Add("Id");

            table1.Rows.Add("Sam", 1);
            table1.Rows.Add("Mark", 2);

            DataTable table2 = new DataTable("Medications");

            table2.Columns.Add("Id");
            table2.Columns.Add("Medication");

            table2.Rows.Add(1, "atenolol");
            table2.Rows.Add(2, "amoxicillin");
            
            DataSet set = new DataSet("Hospital");
            set.Tables.Add(table1);
            set.Tables.Add(table2);

            Console.WriteLine(set.GetXml());

            Console.ReadKey();

        }

 public static void CreateExcelOther(Page page, DataSet ds, string colHeaders, string typeid, string FileName)
 {
     HttpResponse resp;
     resp = page.Response;
     resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
     resp.ContentType = "application/ms-excel";
     resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
     int i = 0;
     System.Data.DataTable dt = ds.Tables[0];
     string bodyData = ExportTable(colHeaders, ds);
     if (typeid == "1")
     {
         resp.Write(bodyData);
     }
     else
     {
         if (typeid == "2")
         {
             //从DataSet中直接导出XML数据并且写到HTTP输出流中
             resp.Write(ds.GetXml());
         }
     }
     //写缓冲区中的数据到HTTP头文件中
     resp.End();
 }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string str = "";
            DataSet Ds = new DataSet();

            DataTable dt = new DataTable();

            dt.Columns.Add("Customer_ID");
            dt.Columns.Add("Service_ID");
            //dt.Columns.Add("Order_ID");

            //for (int i = 0; i < GridView1.Rows.Count; i++)
            //{
            //    var row = dt.NewRow();

            //    row["Customer_ID"] = "28";
            //    row["Service_ID"] = "6";
            //    //row["Order_ID"] = Convert.ToString(GridView1.Rows[i].Cells[0].Text);

            //    dt.Rows.Add(row);
            //}
            var row = dt.NewRow();

            row["Customer_ID"] = Session["ed"].ToString();
            row["Service_ID"] = "6";
            dt.Rows.Add(row);

            Ds.Tables.Add(dt);

            str = Ds.GetXml();

            Session["STR"] = str;

            Response.Redirect("Disconnect_Due.aspx");
        }

        public static string displayemployee(List<string> _arr)
        {
            DataTable dummy = new DataTable();
            dummy.Columns.Add("No");
            dummy.Columns.Add("WorkdayID");
            dummy.Columns.Add("Name");

            SystemObjects.HeadCount _hc = new SystemObjects.HeadCount();
            _hc.TeamID = Convert.ToInt32(_arr[0]);
            _hc.Date =  Convert.ToInt32(_arr[1]);
            _hc.Year = Convert.ToInt32(_arr[2]);
            DataSet ds = new DataSet();
            try
            {
                dummy.Merge(_hc.DisplayEmployee());
                if (dummy.Rows.Count < 1)
                {
                    dummy.Rows.Add();
                }
                ds.Tables.Add(dummy);
            }
            catch (Exception ex)
            {

            }
            return ds.GetXml();
        }

        public static string GetAllDetails(List<string> backArrayParam)
        {
            DataSet data = new DataSet();
            Modules.Ninja ninja = new Modules.Ninja();

            data.Tables.Add(ninja.GetAllDetails());
            return data.GetXml();
        }

        public void CE(string typeid = "1", string FileName = "test.csv")
        {
            DataSet ds = new DataSet();
            DataTable dt = ds.Tables.Add();
            dt.Columns.Add("姓名");
            dt.Columns.Add("年龄");
            dt.Columns.Add("民族");
            dt.Columns.Add("性别");
            dt.Rows.Add("张三", "18", "汉族", "男");
            dt.Rows.Add("张三5", "22", "汉族", "女");
            dt.Rows.Add("张三7", "64", "汉族", "不详");

            HttpResponseBase resp;
            resp = HttpContext.Response;
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName);
            string colHeaders = "", ls_item = "";
            int i = 0;

            //定义表对象与行对像，同时用DataSet对其值进行初始化

            // typeid=="1"时导出为EXCEL格式文件；typeid=="2"时导出为XML格式文件
            if (typeid == "1")
            {
                //取得数据表各列标题，各标题之间以\t分割，最后一个列标题后加回车符
                for (i = 0; i < dt.Columns.Count; i++)
                {
                    colHeaders += dt.Columns[i].Caption.ToString() + ",";
                    //colHeaders += dt.Columns[i].Caption.ToString() + "\n";
                }
                //向HTTP输出流中写入取得的数据信息
                resp.Write(colHeaders + "\r\n");
                //逐行处理数据
                foreach (DataRow row in dt.Rows)
                {
                    //在当前行中，逐列获得数据，数据之间以\t分割，结束时加回车符\n
                    for (i = 0; i < dt.Columns.Count; i++)
                    {
                        ls_item += row[i].ToString() + ",";
                        //ls_item += row[i].ToString() + "\n";
                    }

                    //当前行数据写入HTTP输出流，并且置空ls_item以便下行数据
                    resp.Write(ls_item + "\r\n");
                    ls_item = "";
                }
            }
            else
            {
                if (typeid == "2")
                {
                    //从DataSet中直接导出XML数据并且写到HTTP输出流中
                    resp.Write(ds.GetXml());
                }
            }
            //写缓冲区中的数据到HTTP头文件中
            resp.End();
        }

 public void BindData(DataTable Dt)
 {
     DataSet ds = new DataSet();
     DataTable DtTemp = new DataTable();
     DtTemp = Dt.Copy();
     DtTemp.TableName = "Table";
     ds.Tables.Add(DtTemp);
     BindData(ds.GetXml(), Server.MapPath("~/Xslts/SubscriptionDetails.xslt"));
 }