E:\web\learnaspcom\htdocs\freebook\learn\ubtoc.xml LearnAsp.com - ASP ASP.net Free Lessons
Search Search

#1 worldwide
FREE Coding Lessons
since 1996
   THE BEST WAY to learn ASP & Asp.net!
Advertise Here!
click for details 		Credits Host:
DiscountASP.net 		Server Admin:
The "Team" 		Contact Info.
Charles M. Carroll 		<Asp.net blog>
<personal site>
xxx

C# - XML To DataSet by Charles Carroll

Here is the XML Parser:

   filename=/experiments/xmltodataset/xmltodataset.aspx

<Test Script Below>

 

<%@ import namespace = "System.Data"%>
<%@ import namespace = "System.IO"%>
<script language ="c#" runat ="server">
protected void Page_Load(object sender , EventArgs e)
    {
    FileStream FS=null;
    try
        {
        DataSet ds = new DataSet();
        FS=new FileStream(Server.MapPath("/experiments/data/animalslippers.xml"), FileMode.Open);
        ds.ReadXml(FS);
        string strTableCount=ds.Tables.Count.ToString();
        Trace.Write(" number of tables =" + strTableCount);
        for(int j=0;j<ds.Tables.Count;j++)
            {
            Page.Controls.Add(new LiteralControl("<hr><font color='red'>Table #"+ j +" of " + strTableCount + "</font><br>"));
            DataGrid d1 = new DataGrid();
            
            d1.ID = "MyDataGrid" +j;
            d1.BackColor= System.Drawing.Color.FromName("lightblue");
            d1.Width=Unit.Percentage(100);
            d1.BorderColor=System.Drawing.Color.FromName("black");
            d1.ShowFooter=false;
            d1.CellPadding=3; 
            d1.CellSpacing=0;
            d1.Font.Name="Verdana";
            d1.Font.Size=new FontUnit(10);
            d1.HeaderStyle.BackColor=System.Drawing.ColorTranslator.FromHtml("#aaaadd");
            d1.DataSource = new DataView(ds.Tables[j]);
            d1.DataBind();

            Page.Controls.Add(d1);
            
            }
        } // end try
        
    catch(Exception exc1)
        {
        Trace.Write("blah","blah",exc1);
        } // end catch
    
    finally
        {
        if (FS != null)  FS.Close();            
        } // end finally

    } // end page_load
</script>
Send Us a Holiday Gift!. Charles celebrates Christmas, Jewish holidays, Kwanza, Chinese New Year, Japanese Holidays, Secretary Day, High Muslim Holy Days, Pagan & Wicca holidays, and many more! - send a gift any HOLIDAY. 2004 gift gallery & 2005 gift gallery