Solved

interogating a dataset

Posted on 2004-04-22
4
265 Views
Last Modified: 2010-04-24
Hi
I am using an OracleDataAdapter to populate a dataset to return some data from the database
In the other times I have used this I have used a datagrid or drop down and bound the the control to that.  This time i need to extract from the dataset one single field into a text box.

How do I extract the data from a dataset to get a single value?

regards
0
Comment
Question by:StephenCairns
  • 2
4 Comments
 
LVL 25

Expert Comment

by:RonaldBiemans
ID: 10896958
textbox1.text = dc.tables(0).item("YOUR COLUMN NAME")

0
 
LVL 25

Accepted Solution

by:
RonaldBiemans earned 125 total points
ID: 10896992
Sorry wrong suggestion,

Dm r as datarow = ds.tables(0).rows.find("your primary key Value")

textbox1.text = r.item("your column name")


0
 
LVL 3

Expert Comment

by:Lektran
ID: 10909312
Could explain further as to what the single value will represent?

textbox1.DataSource = dataset.datatable
textbox1.DisplayMember = "column"

you would then have forward and back buttons to move through the dataset
0
 
LVL 10

Author Comment

by:StephenCairns
ID: 10924031
RonaldBiemans
 Thanks for that. I did not have a primary key set up so I used

ds.tables(0).rows.item(0)

the dataset only had one record

thanks to you all for replying

cheers
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question