how to parse xml into combobox?

Question

i have a xml String which contains the following data below

and im tring to parse the Curs section to a combo box which the Display Memeber would be CurName

and the Value Memeber would be CurNo

i have tried many way but with no luck !

im using c# windows forms any help?

<Data><Result>ok</Result>
<RemNo>114</RemNo>
<ListNo>5</ListNo>
<m_bb_cont>0</m_bb_cont>
<m_s_cont>65</m_s_cont>
<m_s_cont_change>1</m_s_cont_change>
<m_s_no>111</m_s_no>
<m_s_no_name>company name</m_s_no_name>
<m_s_no_change>1</m_s_no_change>
<m_use_file>maser</m_use_file>
<m_ss_dob_must>0</m_ss_dob_must>
<m_bb_dob_must>0</m_bb_dob_must>
<m_allow_fraction>1</m_allow_fraction>
<g_issue_id_must>0</g_issue_id_must>
<nat_no_must>0</nat_no_must>
<paytypes><paytype>
<no>1</no>
<name>CASH</name>
</paytype><paytype>
<no>2</no>
<name>CREDIT</name>
</paytype><paytype>
<no>3</no>
<name>other banks</name>
</paytype></paytypes>
<Curs>
<Cur>
<CurNo>2</CurNo>
<CurName>USD</CurName>
<CurCode>USD</CurCode>
</Cur>
<Cur>
<CurNo>9</CurNo>
<CurName>JOD</CurName>
<CurCode>JOD</CurCode>
</Cur>
</Curs>
</Data>

Jignesh Kumar · Answer

Hi, Please use below code. private void Form1_Load( object sender, EventArgs e) { StringBuilder result = new StringBuilder(); DataSet dsResult = new DataSet(); string dsFileName = @ "D:\WindowsFormsDemp\XMLFile1.xml" ; dsResult.ReadXml(dsFileName); comboBox1.DataSource = dsResult.Tables[4]; comboBox1.DisplayMember = "CurName" ; comboBox1.ValueMember = "CurNo" ; }

Omar Kh · Answer

Jignesh Kumar thank u it works fine but how did you come up with this any explianations? Tables[4]?

Rajanikant Hawaldar · Answer

Try as below example Dictionary, dictionary = new Dictionary(); XmlDocument doc = new XmlDocument(); doc.Load(@"D:\WindowsFormsApplication1\WindowsFormsApplication1\XMLFile1.xml"); XmlNodeList elemList = doc.GetElementsByTagName("User"); for (int i = 0; i { string attrVal = elemList[i].Attributes["userID"].Value; dictionary.Add(Convert.ToInt32(attrVal), attrVal); } comboBox1.DataSource = new BindingSource(dictionary, null); comboBox1.DisplayMember = "Key"; comboBox1.ValueMember = "Value";, https://www.experts-exchange.com/questions/28708964/C-populate-combobox-with-data-key-value-from-an-XML-file.html