Click here to Skip to main content
15,896,207 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a page where i want to read the xmlfile and bind the data of it to a dropdownlist .
I am able to read the xml file but how i bind the data .
My xml file is like

<field name="abc" op="<,>,%" value="1">
<field name="xyz" op="<,>,%" value="2">

i want to bind the field name in one dropdown and op in other .
Posted

1 solution

Try this:
C#
public DataTable fnXMLToDataTable(string filePath)
{
    //create the DataTable that will hold the data
    DataTable table = new DataTable("XmlData");
    try
    {
        //open the file using a Stream
        using(Stream stream = new  FileStream(filePath, FileMode.Open, FileAccess.Read))
        {
            //create the table with the appropriate column names
            table.Columns.Add("Name", typeof(string));
            table.Columns.Add("Code", typeof(int));

            //use ReadXml to read the XML stream
            table.ReadXml(stream);

            //return the results
            return table;
        }                
    }
    catch (Exception ex)
    {
        return null;
    }
}

Now call the function and pass XML file Path. Like:
C#
protected void Page_Load(object sender, EventArgs e)
{
     DataTable dt = fnXMLToDataTable("MyFilePath")
     if(dt!=null)
     {
          DropDownList1.DataSource = dt;
          DropDownList1.DataTextField = "Name";
          DropDownList1.DataValueField = "Code";
          DropDownList1.DataBind();
     }
}



--Amit
 
Share this answer
 
Comments
Vimalrashamra 22-Mar-13 22:19pm    
Superb Thanks......
_Amy 22-Mar-13 23:40pm    
Welcome. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900