Solved

interogating a dataset

Posted on 2004-04-22
4
263 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

759 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now