本文整理汇总了C#中System.Data.DataSet.GetXml方法的典型用法代码示例。如果您正苦于以下问题:C# DataSet.GetXml方法的具体用法?C# DataSet.GetXml怎么用?C# DataSet.GetXml使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataSet
的用法示例。
在下文中一共展示了DataSet.GetXml方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: LoadBreadCrumbs
/// <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();
}
示例2: getCountryInXml
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();
}
}
示例3: GetDocketsForUserIdInXML
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();
}
}
示例4: Page_Load
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);
}
}
}
示例5: Page_Load
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);
}
}
}
}
示例6: displayNpt
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();
}
示例7: Page_Load
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"]));
}
示例8: DateDisplay
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();
}
示例9: Main
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();
}
示例10: CreateExcelOther
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();
}
示例11: Button1_Click
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");
}
示例12: displayemployee
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();
}
示例13: GetAllDetails
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();
}
示例14: CE
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();
}
示例15: BindData
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"));
}