Re: How to use DataSets without DataBinding?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Westicle wrote:
Hi all

I am creating a function that is called after a user logs in to my
app; I want the function to use their UPN to return certain details
from a DataSet and then store the values in Session variables so I
can use them throughout the users session. I can access data with a
DataSet and bind it to all sorts of controls until the cows come home
but I have no idea how to pull out individual values from a DataSet.


There was no way for you to know it (except maybe by browsing through
some of the previous questions in this newsgroup before posting yours -
always a recommended practice) , but this is a classic ADO newsgroup.
ADO.Net bears very little resemblance to classic ADO so, while you may
be lucky enough to find a dotnet-knowledgeable person here who can
answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.adonet.

To answer your question, you need to access the relevant datatable in
the dataset (there could be more than one) and then access the DataRows
collection of the datatable to get to the particular DataRow object you
want to work with. The documentation for the DataTable class can be
found here:
http://msdn2.microsoft.com/en-us/library/9186hy08(VS.71).aspx
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.



Relevant Pages

  • Mah-Jongg FAQs updated
    ... FAQ 7f - Added a site that makes an American mah-jongg table expander. ... Introduction to Mah-Jongg Newsgroup ... FAQ11b Origins: Precursor Games ... NEWSGROUP POSTING ARCHIVES: ...
    (rec.games.mahjong)
  • Re: Mahjong FAQs updated
    ... Introduction to Mah-Jongg Newsgroup ... FAQ11b Origins: Precursor Games ... American Mah-Jongg FAQs ... NEWSGROUP POSTING ARCHIVES: ...
    (rec.games.mahjong)
  • FAQ, Frequently Asked Questions autopost
    ... The FAQ will be posted bi-weekly to rasfc and maintained online at ... in the newsgroup or send them to the FAQ maintainer. ... What posting formats are acceptable? ... Manuscript format ...
    (rec.arts.sf.composition)
  • FAQ, Frequently Asked Questions autopost
    ... The FAQ will be posted bi-weekly to rasfc and maintained online at ... in the newsgroup or send them to the FAQ maintainer. ... What posting formats are acceptable? ... Manuscript format ...
    (rec.arts.sf.composition)
  • Mah-Jongg FAQs updated
    ... FAQ 7f - Added a Chinese manufacturer of automatic mahjong tables. ... Introduction to Mah-Jongg Newsgroup ... FAQ11b Origins: Precursor Games ... NEWSGROUP POSTING ARCHIVES: ...
    (rec.games.mahjong)