Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrieving values from a dataset problem

Status
Not open for further replies.

JOBARAM

Programmer
May 25, 2002
52
IL
Hi,
I have created a Dataset that contais a DataTable.
for retrieving a specific value I use the following:

dataSet.Tables.Add("select Data from Data_Type where
product='111'"));

txtProductName.DataBindings.Add("Text", dataSet, "Data_Type.Data")

My problem is that Data_Type table is as follows:

product Type Data
111 1 aaa
111 2 bbb
111 3 ccc
....etc

By using the above code I'm getting 'aaa' (Type 1).
How can I retrieve Type 2 and 3 as well?

Thanks
Yossi
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top