DataSet --xml ！！！

sh1618 2008-05-08 05:32:45

怎么把xml的头部给显示出来！！！<?xml version="1.0"?>
//把各个元素都一一打出来也就是把数据库里的内容用xml显示
private void ForeachXml_Click(object sender, EventArgs e)
{
XmlWriterSettings settings = new XmlWriterSettings();
settings.Indent = true;
settings.OmitXmlDeclaration = true;
settings.NewLineOnAttributes = true;

using (XmlWriter xmlw = XmlWriter.Create(@"f:\fan\test.xml", settings))
{
xmlw.WriteStartDocument();
xmlw.WriteStartElement("students");

xmlw.WriteStartElement("student");

string strconn = "server=.;database=Northwind;uid=sa;pwd=;";
SqlConnection conn = new SqlConnection(strconn);
//可以用 * 或 Name ,age 后面用* 没有影响
string strSql = "select top 10 orderid from orders";
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
DataSet ds = new DataSet();
da.Fill(ds,"orders" );
foreach (DataRow i in ds.Tables["orders"].Rows)
{
xmlw.WriteElementString("orderid", i["orderid"].ToString());

//xmlw.WriteElementString("age",i["age"].ToString());
}

xmlw.WriteEndElement();

xmlw.WriteEndElement();
xmlw.WriteEndDocument();
xmlw.Flush();
xmlw.Close();

}
}

...全文

165 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

otie 2008-05-09

打赏
举报

学习
bangding..

insus 2008-05-09

打赏
举报

Insus.NET做了一下,参考看看,是否合你的要求:



 string connectionString = ConfigurationManager.AppSettings["InsusConnectionString"];



    protected void Page_Load(object sender, EventArgs e)

    {

        SqlConnection conn = new SqlConnection (connectionString);

        string  strSql="SELECT * FROM [NewsType]";

        SqlDataAdapter da = new SqlDataAdapter (strSql,conn);

        DataSet ds = new DataSet ();

        conn.Open ();

        da.Fill (ds);

        conn.Close ();

        

        Response.Write("<?xml version=\"1.0\"?>");

        Response.Write(ds.GetXml ());

        Response.ContentType = "text/xml";

        Response.End();

    }

hm8030 2008-05-09

打赏
举报

這個可以直接轉，也可以自己寫function啊。

指间的风 2008-05-09

打赏
举报

msdn 上找用法吧

wangwei155 2008-05-09

打赏
举报

我也用过3楼的方法

wudi626 2008-05-09

打赏
举报

学习！

lovehongyun 2008-05-09

打赏
举报



private static void DemonstrateGetXml()

{

    // Create a DataSet with one table containing 

    // two columns and 10 rows.

    DataSet dataSet = new DataSet("dataSet");

    DataTable table = dataSet.Tables.Add("Items");

    table.Columns.Add("id", typeof(int));

    table.Columns.Add("Item", typeof(string));



    // Add ten rows.

    DataRow row;

    for(int i = 0; i <10;i++)

    {

        row = table.NewRow();

        row["id"]= i;

        row["Item"]= "Item" + i;

        table.Rows.Add(row);

    }



    // Display the DataSet contents as XML.

    Console.WriteLine( dataSet.GetXml() );

}