unable to bind xml data to ddl linq to xml RSS

• • Reply
  

  .net_junkie

  Member

  297 Points

  825 Posts

  unable to bind xml data to ddl linq to xml

  Jul 23, 2012 06:12 PM|LINK

  I am filling ddl from the xml file below is my code

  public ListItemCollection bind()
          {
              ListItemCollection ddlitems=new ListItemCollection();
              ProfileMasterDAL profileMasterDAL=new ProfileMasterDAL();
              XmlNodeList list = profileMasterDAL.getdata().GetElementsByTagName("country");
              foreach (XmlNode node in list)
              {
                  ListItem item=new ListItem(node.InnerText,node.Attributes["name"].Value);// Object reference not set to an instance of an object.
                      ddlitems.Add(item);
              }
              return ddlitems;
          }

  but i am getting error like Object reference not set to an instance of an object so how to get rid of this?

  <countrys>
    <country>
      <name>India</name>
      <state>
        <text>Maharashtra</text>
        <text>Kashmir</text>
        <text>Goa</text>
      </state>
    </country>
    <country>
      <name>Sri lanka</name>
      <state>
        <text>Kanady</text>
        <text>Colombo</text>
        <text>Galle</text>
      </state>
    </country>
  </countrys>

  
  
  

  It is not about what caused you to fall flat on your back that defines you; it is what you do to get back up on your feet.
  • Edited by .net_junkie on Jul 23, 2012 06:14 PM
• • Reply
  

  Rohit Rao

  Participant

  1869 Points

  357 Posts

  Re: unable to bind xml data to ddl linq to xml

  Jul 23, 2012 06:38 PM|LINK

  here is the code for you:

  protected void Page_Load(object sender, EventArgs e)
      {
          fillCountryList();
      }
  
      private void fillCountryList()
  	{
            //loading your xml from the path
   
              XDocument loaded = XDocument.Load(Server.MapPath(@"~/App_Data/YourXMLFileName.xml"));
  
  
            //get country names from your xml
  
             var countries = from c in loaded.Descendants("countrys").Descendants("country")
  	                    orderby (string)c.Element("name")
  	                    select (string)c.Element("name");
  
            //binding dropdownlist
   
              DropDownList1.DataSource = countries;
  	    DropDownList1.DataBind();
  	}

  Don't forget to Mark As Answer if it helps you.
  
  
  • Edited by Rohit Rao on Jul 23, 2012 06:39 PM
  • Edited by Rohit Rao on Jul 23, 2012 06:41 PM
  • Edited by Rohit Rao on Jul 23, 2012 06:42 PM
  • Edited by Rohit Rao on Jul 23, 2012 06:44 PM
  • Marked as answer by .net_junkie on Jul 24, 2012 03:36 AM
• • Reply
  

  .net_junkie

  Member

  297 Points

  825 Posts

  Re: unable to bind xml data to ddl linq to xml

  Jul 23, 2012 07:16 PM|LINK

  I am using 3 tier architecture for this and how to write BAL and DAL code?

  It is not about what caused you to fall flat on your back that defines you; it is what you do to get back up on your feet.