从SQL表生成XML [英] Generate XML from SQL table

问题描述

我需要从SQL表生成XML。



我需要xml是这样的。

 <？  xml     version   =  1.0    encoding   =  utf-8   < span class =code-summarycomment>？ >  
 <   graph     caption   =' 示例xml'   < span class =code-attribute> xAxisName   =' 国家/地区    
   
             yAxisName   ='  GDP'    showNames   ='  1'    decimalPrecision   ='  0'   < span class =code-attribute> formatNumberScale   ='  0' >  
 <   set     name   =' 卡塔尔'    value   ='  102768'   < span class =code-attribute> color   =' ＃FF0000'    /  >  
 <   set    名称  =' 卢森堡'    value   ='  80679'   颜色  =' ＃00FF00'    /  >  
 <   set     name   =' 新加坡'    value   ='  60883'    color   =' ＃0000FF'    /  >  
 <   set     name   =' 挪威'    value   ='  55264'   颜色  =' ＃00FFFF'    /  >  
 <   set     name   =' 文莱'   值  ='  50526'    color   =' ＃FF00FF'    /  > ;  
 <   set    名称  =' 美国'    value   ='  49802'   颜色  =' ＃FFFF00'    /  >  
 <   set     name   ='  阿联酋'    value  < span class =code-keyword> ='  48992'   颜色  =' ＃FFAAFF'    /  >  
 <   set     name   =' 瑞士'   < span class =code-attribute> value   ='  45285'   颜色  ='  #CCFFBB'    /  >  
 <   set    名称  =' 科威特' < span class =code-attribute>   value   ='  43846'    color   = ' ＃00AABB'    /  >  
 <  设置   名称  =' 奥地利'   值  ='  42477'   颜色  =' ＃BBCCFF'    /  >  
 <   / graph  >  

我的sql表结构将是这样的

名称值颜色
   -     -  ----- ------  
卡塔尔 102768 ＃FF0000 
卢森堡 80679 ＃00FF00 
新加坡 60883  ＃0000FF 
挪威 55264 ＃00FFFF 

我的代码背后会是这样的..



<前lang =c＃> 受保护 void Button1_Click（ object sender，EventArgs e）
{
SqlConnection con = new SqlConnection（ Data Source =。; UID = SA; pwd = wintellect; database = Rohatash;）;
string strSQL = 从详细信息中选择名称，值，颜色;
SqlDataAdapter dt = new SqlDataAdapter（strSQL ，con）;
DataSet ds = new DataSet（）;
dt.Fill（ds， 详细信息）;
ds.WriteXml（Server.MapPath（ Sample_xml_file.xml））;
}

代码没有给我deisred结果。



请帮助获得所需的XML输出。

解决方案

使用 LINQ 来做到这一点。这是一个例子：

使用LINQ从数据库创建xml [ ^ ]

访问此处....





http：// msdn.microsoft.com/en-us/library/system.data.datatable.writexml.aspx [ ^ ]

Hi,

I need to generate XML from a SQL table.

My xml need to be like this.

<?xml version="1.0" encoding="utf-8" ?>
<graph caption='Sample xml' xAxisName='Country' 

     yAxisName='GDP' showNames='1' decimalPrecision='0' formatNumberScale='0'>
  <set name='Qatar' value='102768' color='#FF0000' />
  <set name='Luxembourg' value='80679' color='#00FF00' />
  <set name='Singapore' value='60883' color='#0000FF' />
  <set name='Norway' value='55264' color='#00FFFF' />
  <set name='Brunei' value='50526' color='#FF00FF' />
  <set name='United States' value='49802' color='#FFFF00' />
  <set name='UAE' value='48992' color='#FFAAFF' />
  <set name='Switzerland' value='45285' color='#CCFFBB' />
  <set name='Kuwait' value='43846' color='#00AABB' />
  <set name='Austria' value='42477' color='#BBCCFF' />
</graph>

My sql table structure will be like this

Name	    Value       Color
----         -----       ------
Qatar	    102768      #FF0000
Luxembourg   80679	#00FF00
Singapore    60883	#0000FF
Norway	    55264	#00FFFF

My code behind will be like this..

protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Data Source=.; uid=sa; pwd=wintellect;database=Rohatash;");
            string strSQL = "Select name, value, color from Details";
            SqlDataAdapter dt = new SqlDataAdapter(strSQL, con);
            DataSet ds = new DataSet();
            dt.Fill (ds,"Details");
            ds.WriteXml(Server.MapPath("Sample_xml_file.xml"));
        }     

This code is not giving me deisred result.

Please help to get the desired XML output.

解决方案

Use LINQ to do that.Here is an example:
Create xml from database using LINQ[^]

visit here....


http://msdn.microsoft.com/en-us/library/system.data.datatable.writexml.aspx[^]

这篇关于从SQL表生成XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！