Ggtcf

Would a grinding machine be a simple and workable propulsion system for an interplanetary spacecraft?

Does the Idaho Potato Commission associate potato skins with healthy eating?

Decide between Polyglossia and Babel for LuaLaTeX in 2019

How to get the last not-null value in an ordered column of a huge table?

How to set page number in right side in chapter title page?

How do I fit a non linear curve?

What day is it again?

What can the phrase “is embedded in a whale of a bill” mean?

Is it correct to say moon starry nights?

Expectation in a stochastic differential equation

My ex-girlfriend uses my Apple ID to login to her iPad, do I have to give her my Apple ID password to reset it?

What connection does MS Office have to Netscape Navigator?

Reference request: Grassmannian and Plucker coordinates in type B, C, D

How to find image of a complex function with given constraints?

How to use ReplaceAll on an expression that contains a rule

Is there a way to save my career from absolute disaster?

What CSS properties can the br tag have?

Players Circumventing the limitations of Wish

Aggressive Under-Indexing and no data for missing index

Is it ever safe to open a suspicious HTML file (e.g. email attachment)?

Is it ok to trim down a tube patch?

Is it okay to majorly distort historical facts while writing a fiction story?

Would a completely good Muggle be able to use a wand?

Expressing the idea of having a very busy time

Fetch data from xml file to textbox on selecting an item from combobox. How can this be achieved?

0

XML file:

<?xml version="1.0" encoding="UTF-8"?>
<employees>
 <employee>
 <name>John</name>
 <salary>29000</salary> 
 </employee>

 <employee>
 <name>Harry</name>
 <salary>35000</salary> 
 </employee>
</employees>

Here i'm populating the employee names from xml file in the combobox

XmlDocument doc = new XmlDocument();
doc.Load(path);
XmlNodeList colorList = doc.SelectNodes("employees/employee/name");
foreach (XmlNode Name in colorList)

 FeedComboBox.Items.Add(Name.InnerText);

What I'm trying to achieve is that if I select John from the combo-box I need to fetch the value of John's salary (29000) from the XML file & display it in the textbox

c# xml winforms combobox

share|improve this question

asked Mar 8 at 17:06

Code WinesCode Wines

1668

add a comment | 

0

XML file:

<?xml version="1.0" encoding="UTF-8"?>
<employees>
 <employee>
 <name>John</name>
 <salary>29000</salary> 
 </employee>

 <employee>
 <name>Harry</name>
 <salary>35000</salary> 
 </employee>
</employees>

Here i'm populating the employee names from xml file in the combobox

XmlDocument doc = new XmlDocument();
doc.Load(path);
XmlNodeList colorList = doc.SelectNodes("employees/employee/name");
foreach (XmlNode Name in colorList)

 FeedComboBox.Items.Add(Name.InnerText);

What I'm trying to achieve is that if I select John from the combo-box I need to fetch the value of John's salary (29000) from the XML file & display it in the textbox

c# xml winforms combobox

share|improve this question

asked Mar 8 at 17:06

Code WinesCode Wines

1668

add a comment | 

XML file:

<?xml version="1.0" encoding="UTF-8"?>
<employees>
 <employee>
 <name>John</name>
 <salary>29000</salary> 
 </employee>

 <employee>
 <name>Harry</name>
 <salary>35000</salary> 
 </employee>
</employees>

Here i'm populating the employee names from xml file in the combobox

XmlDocument doc = new XmlDocument();
doc.Load(path);
XmlNodeList colorList = doc.SelectNodes("employees/employee/name");
foreach (XmlNode Name in colorList)

 FeedComboBox.Items.Add(Name.InnerText);

What I'm trying to achieve is that if I select John from the combo-box I need to fetch the value of John's salary (29000) from the XML file & display it in the textbox

c# xml winforms combobox

share|improve this question

asked Mar 8 at 17:06

Code WinesCode Wines

1668

<?xml version="1.0" encoding="UTF-8"?>
<employees>
 <employee>
 <name>John</name>
 <salary>29000</salary> 
 </employee>

 <employee>
 <name>Harry</name>
 <salary>35000</salary> 
 </employee>
</employees>

XmlDocument doc = new XmlDocument();
doc.Load(path);
XmlNodeList colorList = doc.SelectNodes("employees/employee/name");
foreach (XmlNode Name in colorList)

 FeedComboBox.Items.Add(Name.InnerText);

share|improve this question

asked Mar 8 at 17:06

Code WinesCode Wines

1668

share|improve this question

asked Mar 8 at 17:06

Code WinesCode Wines

1668

asked Mar 8 at 17:06

Code WinesCode Wines

1668

asked Mar 8 at 17:06

Code WinesCode Wines

1668

2 Answers
2

active

oldest

votes

1

This should do it

var root = XElement.Parse(stringxml);
var empName = "John"; // This will be the string you select from combobox
var query = root
 .XPathSelectElements(string.Format("/employee[name='0']", empName))
 .Select(et => new
 
 salary = (string)et.Element("salary"),
 );

var results = query.ToList();
TextBox.Text = results[0].salary; // Set the Salary to the textbox

share|improve this answer

answered Mar 10 at 5:46

Tim SmithTim Smith

526

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks a lot that worked!
  
  – Code Wines
  Mar 10 at 12:35
  

  
  
  
  

add a comment | 

1

Just select the employee element instead, and you can access its child elements via the indexer ([]):

foreach(XmlNode employee in doc.SelectNodes("employees/employee"))

 var name = employee["name"].InnerText;
 var salary = employee["salary"].InnerText;

 FeedComboBox.Items.Add($"name (salary)");

share|improve this answer

answered Mar 8 at 17:42

Xiaoy312Xiaoy312

11.5k12234

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This doesn't fulfill my requirement. Basically, I have a string say 'Harry' so I want to fetch the salary (35000) of the employee Harry from xml file & display in the text box.
  
  – Code Wines
  Mar 10 at 4:14
  

  
  
  
  

add a comment | 

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55067849%2ffetch-data-from-xml-file-to-textbox-on-selecting-an-item-from-combobox-how-can%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

This should do it

var root = XElement.Parse(stringxml);
var empName = "John"; // This will be the string you select from combobox
var query = root
 .XPathSelectElements(string.Format("/employee[name='0']", empName))
 .Select(et => new
 
 salary = (string)et.Element("salary"),
 );

var results = query.ToList();
TextBox.Text = results[0].salary; // Set the Salary to the textbox

share|improve this answer

answered Mar 10 at 5:46

Tim SmithTim Smith

526

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks a lot that worked!
  
  – Code Wines
  Mar 10 at 12:35
  

  
  
  
  

add a comment | 

1

This should do it

var root = XElement.Parse(stringxml);
var empName = "John"; // This will be the string you select from combobox
var query = root
 .XPathSelectElements(string.Format("/employee[name='0']", empName))
 .Select(et => new
 
 salary = (string)et.Element("salary"),
 );

var results = query.ToList();
TextBox.Text = results[0].salary; // Set the Salary to the textbox

share|improve this answer

answered Mar 10 at 5:46

Tim SmithTim Smith

526

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks a lot that worked!
  
  – Code Wines
  Mar 10 at 12:35
  

  
  
  
  

add a comment | 

This should do it

var root = XElement.Parse(stringxml);
var empName = "John"; // This will be the string you select from combobox
var query = root
 .XPathSelectElements(string.Format("/employee[name='0']", empName))
 .Select(et => new
 
 salary = (string)et.Element("salary"),
 );

var results = query.ToList();
TextBox.Text = results[0].salary; // Set the Salary to the textbox

share|improve this answer

answered Mar 10 at 5:46

Tim SmithTim Smith

526

var root = XElement.Parse(stringxml);
var empName = "John"; // This will be the string you select from combobox
var query = root
 .XPathSelectElements(string.Format("/employee[name='0']", empName))
 .Select(et => new
 
 salary = (string)et.Element("salary"),
 );

var results = query.ToList();
TextBox.Text = results[0].salary; // Set the Salary to the textbox

share|improve this answer

answered Mar 10 at 5:46

Tim SmithTim Smith

526

answered Mar 10 at 5:46

Tim SmithTim Smith

526

answered Mar 10 at 5:46

Tim SmithTim Smith

526

1

Just select the employee element instead, and you can access its child elements via the indexer ([]):

foreach(XmlNode employee in doc.SelectNodes("employees/employee"))

 var name = employee["name"].InnerText;
 var salary = employee["salary"].InnerText;

 FeedComboBox.Items.Add($"name (salary)");

share|improve this answer

answered Mar 8 at 17:42

Xiaoy312Xiaoy312

11.5k12234

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This doesn't fulfill my requirement. Basically, I have a string say 'Harry' so I want to fetch the salary (35000) of the employee Harry from xml file & display in the text box.
  
  – Code Wines
  Mar 10 at 4:14
  

  
  
  
  

add a comment | 

1

Just select the employee element instead, and you can access its child elements via the indexer ([]):

foreach(XmlNode employee in doc.SelectNodes("employees/employee"))

 var name = employee["name"].InnerText;
 var salary = employee["salary"].InnerText;

 FeedComboBox.Items.Add($"name (salary)");

share|improve this answer

answered Mar 8 at 17:42

Xiaoy312Xiaoy312

11.5k12234

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  This doesn't fulfill my requirement. Basically, I have a string say 'Harry' so I want to fetch the salary (35000) of the employee Harry from xml file & display in the text box.
  
  – Code Wines
  Mar 10 at 4:14
  

  
  
  
  

add a comment | 

Just select the employee element instead, and you can access its child elements via the indexer ([]):

foreach(XmlNode employee in doc.SelectNodes("employees/employee"))

 var name = employee["name"].InnerText;
 var salary = employee["salary"].InnerText;

 FeedComboBox.Items.Add($"name (salary)");

share|improve this answer

answered Mar 8 at 17:42

Xiaoy312Xiaoy312

11.5k12234

foreach(XmlNode employee in doc.SelectNodes("employees/employee"))

 var name = employee["name"].InnerText;
 var salary = employee["salary"].InnerText;

 FeedComboBox.Items.Add($"name (salary)");

share|improve this answer

answered Mar 8 at 17:42

Xiaoy312Xiaoy312

11.5k12234

answered Mar 8 at 17:42

Xiaoy312Xiaoy312

11.5k12234

answered Mar 8 at 17:42

Xiaoy312Xiaoy312

11.5k12234