Getting value from stored procedure

[yonelay]

I have a sp that has firstname, lastname, fullname, and personid columns. In my C#, I have a drop down which displaymember is fullname and valuemember is personid. So far so good, I got those values. Now, I want firstname and lastname of the selected person from the dropdown. How do I do that? Someone suggested me to use Rows[0]["firstname"], but it only gave me the firstname and lastname of the first record displayed, not selected.

Can anyone please help me?

 

[IT4EVR]

If I am right,on the selectedindexchanged event you can derive the text portion of the dropdown with the dropdown.selecteditem property.

 

[cappmgr]

try this, personid must be unique
string expression = "personid = dd.SelectedItem.value");
foundIndex = yourtable.Select(expression);
Rows[foundIndex]["firstname"]

Marty

 

[cappmgr]

syntax is wrong but I think you have the idea
should have been something like this
string expression = "personid = " + dd.SelectedItem.value;

Marty

 

[yonelay]

Thanks for the answers.

Here is the respond I got from other post.

Rows[dropdownname.SelectedIndex]["firstname"]

 

[cappmgr]

I do not see how that could work unless the SelectedIndex is the same as your personid.

Marty

 

[cappmgr]

DataRow[] foundRows;
string expression = "personid = " + dd.SelectedItem.value;
//yourtable is the same table you used for your dd
foundRows = yourtable.Select(expression);
int foundIndex = foundRows[0][personid column name or position];
string firstName = yourtable.Rows[foundIndex]["firstname"];

I only have access to a command line and text editor so I won't test it.
Marty

 

[yonelay]

Thanks a lot.