Problem deserializing XML

Question

OK I have my XML Deserializer working I can see the data in the object. I'm trying to set it as the datasource of a combo box now but it's not working. I used the XSD to create the class. I even made a List but I can't find the right DisplayMemeber etc to use. The item fields are buried pretty deep. I'm new to using objects some of the elements support ToList but that seems odd too. This may be overkill for my little project I just want to practice using XML in different ways I'm wanting to populate a listBox and when I click the item it displays the body of the text element in a richTextBox. The data will be stored in an XML file.

Jason · Answer

Ok everything works fine now using this method I'll mess around with serialization later. private void loadlist() { this.cmbProject.Items.Clear(); this.listBox1.Items.Clear(); XmlDocument xmlDoc = new XmlDocument(); //* create an xml document object. xmlDoc.Load(projects.xml); //* load the XML document from the specified file. //* Get elements. XmlNodeList nl = xmlDoc.GetElementsByTagName(storedproc); //Add all the projects to the combo box from the proj attribute for (int i = 0; i { //Check to see if it already exists in the combo box if not add it if (!this.cmbProject.Items.Contains(nl[i].Attributes[proj].Value)) cmbProject.Items.Add(nl[i].Attributes[proj].Value); } } private void cmbProject_SelectedIndexChanged(object sender EventArgs e) { XmlDocument xmlDoc = new XmlDocument(); //* create an xml document object. xmlDoc.Load(projects.xml); //* load the XML document from the specified file. //* Get elements. XmlNodeList nl = xmlDoc.GetElementsByTagName(storedproc); this.listBox1.Items.Clear(); for (int i = 0; i { if (cmbProject.SelectedItem.ToString() == nl[i].Attributes[proj].Value) //if the combo box selection = the current node attribute proj value { listBox1.Items.Add(nl[i].Attributes[name].Value); //Gets the stored proc name txtProject.Text = nl[i].Attributes[proj].Value; //Gets the project name from the attribute } } } Also a button to save changes and keep my SQL format safe using CDATA private void btnSave_Click(object sender EventArgs e) { XmlDocument xmlDoc = new XmlDocument(); //* create an xml document object. xmlDoc.Load(projects.xml); //* load the XML document from the specified file. XmlElement xRoot = xmlDoc.DocumentElement; //Creates the base xmlDoc object XmlElement xStoredProc = xmlDoc.CreateElement(storedproc); //Creates the element based on an existing element in your XML file XmlCDataSection xValue = xmlDoc.CreateCDataSection(this.richTextBox1.Text); //Creates the CDATA section xStoredProc.SetAttribute(name textBox1.Text); //Saves the attribute value for the name attribute xStoredProc.SetAttribute(proj txtProject.Text); //Same as above but usinge proj xRoot.AppendChild(xStoredProc); //adds the attributes to the node xRoot.LastChild.AppendChild(xValue); //adds the CDATA section to the node xmlDoc.Save(projects.xml); this.button1.Visible = false; this.listBox1.Items.Clear(); loadlist(); }

Jason · Answer

I've used objects to populate Lists and use them as datasources but those objects had a more friendly structure I guess. I may try to just change the generated class a bit. Seems like it should be more straight forward though. I just want to load the listbox with all attributes then put the text element in a textbox etc. I successfully pulled all the attributes before and the list box was fine but I never could get it to find the text element attached to the attribute. So I switched to trying the Serializer.

Sam Hobbs · Answer

Since this is for learning it might be educational to use the Data Sources window. Do you know what I mean? Do you know how to do that? You can try it and if it works then you can look at the source code that is generated. I have not used XSD to generate classes and then use that code. I have written code to serialize and deserialize simple XML; I wrote an article about that. I recently learned about XSD and I have used it to generate a schema from XML and classes from the schema but that is as far as I got. I suppose that I can try to create a data source from the classes but I probably need to spend a little more time analyzing the data. Try using the Data Sources window; hopefully it will work. Also I assume you are using the XmlSerializer class since you are using XSD and you say you have a  XML Deserializer working . If you are not using the XmlSerializer class then what are you using?

Jason · Answer

Just just trying to use the DisplayMember and Valuemember properties for the listBox then set the DataSource to the object that I get from using the class that XSD generated. I can see the data when I debug it's buried in the object.

Sam Hobbs · Answer

It is not clear to me what you need help with. You say you are trying to set it as the datasource of a combo box. How are you doing that? Are you using the Data Sources window to do that?

Mayur Dighe · Answer

Hey Jason Try this Code ..... DataSet Dset = new DataSet (); Dset.ReadXml( ..\..\XMLData.xml ); for ( int item=0; item { comboBox1.Items.Add(Dset.Tables[item].TableName.ToString()); } private void comboBox1_SelectedIndexChanged( object sender EventArgs e) { listBox1.DataSource = null ; listBox1.DataSource = Dset.Tables[comboBox1.Text]; } private void listBox1_SelectedIndexChanged( object sender EventArgs e) { //this will work if you have Body Column in you XML File //you can change the name of the field richTextBox1.Text=Dset .Tables[comboBox1.Text]. Rows[listBox1.SelectedItem().toString()][Body].ToString() ; }