Sunday, April 8, 2012

XML and C#

<Questions>
<question>
    <id>0</id>
    <value>0</value>
    <name>Select One</name>
  </question>
  <question>
    <id>1</id>
    <value>1</value>
    <name>What is your favourite movie?</name>
  </question>
  <question>
    <id>2</id>
    <value>2</value>
    <name>What is the city where you were born?</name>
  </question>
  <question>
    <id>3</id>
    <value>3</value>
    <name>What is your high school name?</name>
  </question>
</Questions>

read xml and bind to DropDownList            string myXMLfile = Server.MapPath("~/Data/SecurityQ.xml");
            DataSet ds = new DataSet();
            try
            {
                ds.ReadXml(myXMLfile);
                ddlSecurityQ.DataSource = ds;
                ddlSecurityQ.DataValueField = "value";
                ddlSecurityQ.DataTextField = "name";
                ddlSecurityQ.DataBind();
            }
            catch (Exception ex)
            {
            }

<Questions>
  <question id="0" value="0" name="Select One"></question>
  <question id="1" value="1" name="What is your favourite movie?"></question>
  <question id="2" value="2" name="What is the city where you were born?"></question>
  <question id="3" value="3" name="hat is your high school name?"></question>
</Questions>

 string myXMLfile = Server.MapPath("~/Data/SecurityQ.xml");
            XmlDocument xmldoc = new XmlDocument();
            xmldoc.Load(myXMLfile);
            XmlNodeList list = xmldoc.GetElementsByTagName("Questions")[0].ChildNodes;
            ddlSecurityQ.Items.Clear();
            for (int i = 0; i < list.Count; i++) {
                ddlSecurityQ.Items.Add(new ListItem(list[i].Attributes["name"].Value, list[i].Attributes["value"].Value));
            }  

No comments:

Post a Comment