How to read xml into ListBox And TextBoxes

Question

I wont to read xml file so that ListBox is populated by the first column values of the xml table.

If some items in ListBox is selected - textboxes should display the corresponding vallue (column/row) from xml table.

Also - if I change the value of listBox or texboxes - how to update xml file.

In one word - i need an funktional xml one-table-database.

Is it possible? I tried menu times, but...
I use visual c# - studio 2010.

Thanks a lot - in advance.

Sam Hobbs · Answer

Your question is actually multipel questions. One of them is the question of how to read (and write) XML data. There are many articles in this web site about that; I wrote one.

Senthilkumar · Answer

Hi ListBox1.DataSource = ds.Tables[0]; ListBox1.DisplayMember = ds.Tables[0].Columns[0].ToString(); ListBox1.ValueMember = ds.Tables[0].Columns[1].ToString()+&+ds.Tables[0].Columns[1].ToString(); ListBox1.DataBind();

Memento · Answer

Senthilkumar ListBox1.DataSource = ds.Tables[0]; - ok ListBox1.DisplayMember = ds.Tables[0].Columns[0]; - error: Cannot implicitly convert type 'System.Data.DataColumn' to 'string' C:\Documents and Settings\... ListBox1.DataBind(); - error: System.Windows.Forms.ListBox' does not contain a definition for 'DataBind' and no extension method 'DataBind' accepting a first argument of type 'System.Windows.Forms.ListBox' could be found (are you missing a using directive or an assembly reference?) C:\Documents and Settings\... I really hope - YouHaveGoodNerves

Senthilkumar · Answer

Hi You did not mention whether it is web or win forms. anyway ListBox1.DataSource = ds.Tables[0]; ListBox1.DisplayMember = ds.Tables[0].Columns[0]; ListBox1.ValueMember = ds.Tables[0].Columns[1]+&+ds.Tables[0].Columns[1]; ListBox1.DataBind(); in the ListBox event private void ListBox1_SelectedIndexChanged(object sender EventArgs e) { if (ListBox1.SelectedIndex > -1) { string strSelectedItem = ListBox1.SelectedValue.ToString(); string[] splitItems = strSelectedItem.Split(new char[] { '&' }); TextBox1.Text = splitItems[0]; TextBox2.Text = splitItems[1]; } } Hope this will help you.

Memento · Answer

Senthilkumar ThankYou for you efforts and especially for gived link - i learnd something reading it. Excuse for my ignorence but i see that i dont explained my problem correctly. I'm making small desktop application. Your code: ListBox1.DataSource = ds.Tables[0]; - works well butt: ListBox1.DataTextField = ds.Tables[0].Columns[0]; ListBox1.DataValueField = ds.Tables[0].Columns[0]; ListBox1.DataBind(); on that lines i have errors: System.Windows.Forms.ListBox' does not contain a definition for 'DataValueField' and no extension method 'DataValueField' accepting a first argument of type... I have no such properties for my listbox. Also when i click on a ListBox i dont need in a textbox selected value but: for example if my datatable is something like: 1 2 3 5 6 7 a b c In the lisbox i need items: 1 5 a (this is first column of my datatable) When I select 1 (in listbox): first textbox should be - 2 second textbox should be - 3 When I select 5 (in listbox): first textbox should be - 6 second textbox should be - 7 and so on. Thank You Once More.

Senthilkumar · Answer

Hi If you want to read the XML file then you can use the DataSet. DataSet ds = new DataSet(); ds.ReadXml(xmlfilePath); ListBox1.DataSource = ds.Tables[0]; ListBox1.DataTextField = ds.Tables[0].Columns[0]; ListBox1.DataValueField = ds.Tables[0].Columns[0]; ListBox1.DataBind(); You need to have two controls. onselectedindexchanged=ListBox1_SelectedIndexChanged Width=340px> Here you need to write the select index change event and make the auto post back property as true. protected void ListBox1_SelectedIndexChanged(object sender EventArgs e) { txtSelectItem.Text = ListBox1.SelectedItem.Text; } Now it will show the selected item in the textbox. When change the value in the textbox if you want to save then you need to identify the row and update it. http://support.microsoft.com/kb/301233 Hope this will help you.