InfoPath Dev

hello,

i fill my listbox with a dataconnection to a sql-server. the listbox shows e.g. all cars available for rent. any entry gets a id as value from the sql-table. now i want to use the choosen entry in my c# code. i do not need the car, i need the value (id) of that. i tryed to get this by thisXDocument.DOM.selectSingleNode("my:myFields/my:Car").text but this don`t gets the id. how can i get the value?

thx
mephisto

1) Double-click on your listbox in design mode and at the bottom where you have connected the list to a SQL database, you can choose what field you want to be the "Value" and what field you want to be the "Display Name". When you call selectSingleNode("...").text it will return the value of the field that you chose for "Value", not "Display Name". "Display Name" is simply what the user sees when they drop down the menu. Make sure that the "Display Name" is textual, but the MAIN thing that you need to do is make the "Value" field correspond with you "id" from your database.

2) After you have done this, things will be a lot easier and you can query your database from within your code to gather all the information you could want. Your query statement would look like this:

"SELECT * FROM _table_ WHERE id = \"" + parseInt(thisXDocument.DOM.selectSingleNode("my:myFields/my:Car").text) + "\""

Of course, your code will be different depending on what language you're using (not exactly sure on yours), but you should get the gist of it.

---------------
Matt Faus

hello MFaus,

thx for your answer! now i get the right id to query the sql-database!!! in my infopath-form the value and display-name was the same .... now i have the id as value ;-)

thx very much

mephisto