[thelist] Classic to Asp.NET 2.0

[Peter Brunone (EasyListBox.com)]

		Hi Rob,

   Can you be a bit more specific about the task at hand?

   I think you may be confusing ObjectDataSources (a .NET 2.0 concept) with datareaders and datasets.  The latter two are structures which hold data (assumedly returned from a query) whereas the former is a new web control that provides data to a bound control in some form.

   You can still retrieve data using SqlCommand.ExecuteDataReader or SqlDataAdapter.Fill (google on either of these for examples).  Then it's just a matter of retrieving the fields you need.  Of course if you just need to return one value, there's always SqlCommand.ExecuteScalar...

   I highly recommend downloading Reflector ( http://www.aisto.com/roeder/dotnet ), a free class browser that will let you walk namespaces and classes at your leisure.

HTH,

Peter

				From: "Rob Smith" rob.smith at lexjet.com

I'm starting to take the leap here switching languages and paradigms but
I'm running into a few hurdles. It was and is still easy for me to
retrieve data from a single cell using record sets in classic. However,
most of the stuff I've come across in .NET 2.0 wants the record set or
now dataset to be bound to some control object, which isn't always
exactly what I need. Can someone post or provide a link of how to do
this. I've searched four about a half a day looking for the most simple
of example. 

Thanks, 

Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236