Search through data returned from stored procedure

[CSINVA]

I have a stored procedure that returns columns from a table called
UserProfile. Within the table, it has a column called ProfielD,
PropertyValue, Visitbility. I need to be able set the values returned
to a variable to be used later. Here is an example of the data
without filtering stored procedure:

ProfileID, UserID, PropertyDefinitation, PropertyValue,Visibiity
31, 3, 20, Prefix, 2
32, 3, 22, Suffix, 2
33, 3, 25, unit, 2
34, 3, 30, zip, 2
35, 4, 20, Prefix, 2
36, 4, 22, Suffix, 2
37, 4, 25, unit, 2

I created the stored procedure to take a @userID parameter so only the
rows with the appropriate userID would be displayed.

So now my data looks like when filtered with userID = 3

ProfileID, UserID, PropertyDefinitation, PropertyValue,Visibiity
31, 3, 20, Prefix, 2
32, 3, 22, Suffix, 2
33, 3, 25, unit, 2
34, 3, 30, zip, 2

Now I need to:

Assign the value in the PropertyValue column where it is equal to a
particual number in the PropertyDefinitation column, such as:

txtPrefix = Number 20 - Prefix
txtPrefixVisibility = Number 20 - Visibility
txtSuffix = Number 22 - Suffix
txtPrefixVisibility = Number 22 - Visibility
txtUnit = Number 25 - Unit
txtUnitVisibility = Number 25 - Visibility
txtZip = Number 30 - Zip
txtZipVisibiity = Number 30 - Visibility

[Eliyahu Goldin]

Have your data returned to a DataTable. Then you can use DataTable.Select
method to locate required rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"CSINVA" <mc*************@yahoo.comwrote in message
news:11*********************@z9g2000hsf.googlegrou ps.com...

>I have a stored procedure that returns columns from a table called
UserProfile. Within the table, it has a column called ProfielD,
PropertyValue, Visitbility. I need to be able set the values returned
to a variable to be used later. Here is an example of the data
without filtering stored procedure:

ProfileID, UserID, PropertyDefinitation, PropertyValue,Visibiity
31, 3, 20, Prefix, 2
32, 3, 22, Suffix, 2
33, 3, 25, unit, 2
34, 3, 30, zip, 2
35, 4, 20, Prefix, 2
36, 4, 22, Suffix, 2
37, 4, 25, unit, 2

I created the stored procedure to take a @userID parameter so only the
rows with the appropriate userID would be displayed.

So now my data looks like when filtered with userID = 3

ProfileID, UserID, PropertyDefinitation, PropertyValue,Visibiity
31, 3, 20, Prefix, 2
32, 3, 22, Suffix, 2
33, 3, 25, unit, 2
34, 3, 30, zip, 2

Now I need to:

Assign the value in the PropertyValue column where it is equal to a
particual number in the PropertyDefinitation column, such as:

txtPrefix = Number 20 - Prefix
txtPrefixVisibility = Number 20 - Visibility
txtSuffix = Number 22 - Suffix
txtPrefixVisibility = Number 22 - Visibility
txtUnit = Number 25 - Unit
txtUnitVisibility = Number 25 - Visibility
txtZip = Number 30 - Zip
txtZipVisibiity = Number 30 - Visibility