<html><div style='background-color:'><DIV>
<P>Dataset retrieves entire data results into a table in the data set. Take the time to understand how they work and they're
not much trouble. but you maybe interested in the IDataReader also, it works more like a "input-only stream" from de database, which
allow you not to retrieve a huge amount of data if it's your case (if you don't have to update the DB with your dataset or
datatable, it may be a good choice.</P>
<P>hope it helps for now... : )~</P>
<P> </P>
<P>Sebastian (aka Ryders)<BR>CGI inc.</P>
<P> </P>
<P>> -----Original Message-----<BR>> From: Hugh McLaughlin [<A
href="http://pv0fd.pav0.hotmail.msn.com/cgi-bin/compose?mailto=1&msg=MSG1015545012.33&start=1433425&len=3335
1&src=&type=x&to=hugh%40kmcnetwork%2ecom&cc=&bcc=&subject=&body=&cur
mbox=F000000001&a=656401d16ba1c2534e54b8df5e3b6211" target=_top><FONT
color=#000099>mailto:hugh@k...</FONT></A>]<BR>> Sent: Thursday, March 07, 2002 11:24
AM<BR>> To: ASP+<BR>> Subject: [aspx] Referencing Individual Data
Columns<BR>><BR>><BR>> Hello everyone and thanks for your help in advance. I am
currently<BR>> working with a SQL Server table and want to be able to execute a query<BR>> that returns
data from one column in the table. I am using a DataSet to<BR>> access the table. What I want to do
is to set a variable equal to the<BR>> value in that table, for example in classic
ASP<BR>><BR>> strFirstName=rstemp("FirstName")<BR>><BR>> I can't seem to figure
out how to do this since most examples imply push<BR>> the dataset into a datagrid for display. Not entirely
sure that the<BR>> dataset is even the best method. Any help would be greatly appreciated.<BR>>
Thanks.<BR>> ---<BR>> Change your mail options at <A
href="http://64.4.32.251/cgi-bin/linkrd?_lang=EN&lah=7475ecf39a2d526c852ffcfd158f3769&lat=1015604161&hm___ac
tion=http%3a%2f%2fp2p%2ewrox%2ecom%2fmanager%2easp" target=_blank><FONT
color=#000099>http://p2p.wrox.com/manager.asp</FONT></A> or<BR>>
.<BR></P><?xml:namespace prefix = mailto /><mailto:$subst('Email.Unsub')>
<DIV></DIV>
<DIV></DIV></mailto:$subst('Email.Unsub')></DIV></div><br clear=all><hr>Chat with friends
online, try MSN Messenger: <a href='http://g.msn.com/1HM100901/o'>Click Here</a><br></html>
View Cart
