Adding/Deleting items from a databound listbox

Question

Hi,

I recently databounded an xml file to a listbox. Now I want to write some function to add or delete items from that listbox. The following error came up while trying listbox.items.add or listbox.items.insert:

Access and modify elements with ItemsControl.ItemsSource instead.

I googled this and it said to work on the 'model' instead,

However I have no clue how to do that. So how can I add or delete items to and from the datasource? I would hate having to add xml elements and values to the original and then update the file as the data source...

Answer 1

How about loading the XML into a dataset and then manipulating the dataset and rebinding?

Instead of using the XML file and binding that to the listbox, try this: (source)

 string myXMLfile = "C:\\MySchema.xml";
    DataSet ds = new DataSet(); 
    try
    {
        //reads file and loads data into dataset
        ds.ReadXml(myXMLfile);
        //set the listbox's datasource to the dataset
        //note that if you have complex XML then you might need to set this to one of the datatables in the datset to get what you want
        listBox1.DataSource = ds;
        listBox1.DataBind();
    }
    catch (Exception ex)
    {
      //Handle error
    }

Lets assume you XML is rather simple. To add a tow to the DataSet you would do: (source)

//if customers is the name of your table (have not seen your XML)
DataRow newCustomersRow = ds.Tables["Customers"].NewRow();

newCustomersRow["CustomerID"] = "ALFKI";
newCustomersRow["CompanyName"] = "Alfreds Futterkiste";

dataSet1.Tables["Customers"].Rows.Add(newCustomersRow);

Here is an XML example that should work with the above:

<Data>
  <Customers>
    <Customer>
      <CustomerID>123</CustomerID>
      <CompanyName>Name</CompanyName>
    </Customer>
  </Customers>
</Data>

I have not compiled or tried to run any of that, but you should get the general idea and adapt it to your code.