473,320 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

simple question

I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.
Dec 7 '07 #1
9 2339
Well, that question is actually a bit more complicated now, since in ASP
..NET and ADO .NET, we don't have recordsets any more.

If you are looking for a connected, read-only, and forward-only way of
iterating over your results, you can use a DataReader once you've executed
your command and then loop through it so you can see your returned records
one by one.

If you need to persist your data a bit longer than this, or if you need to
be able to back up through the records, ADO .NET provides us with a DataSet
(which is like an in memory relational database). A DataSet is disconnected
from the source of the data so, you can access your data at any time after
populating your DataSet by accessing the table(s) of data that it contains
and then the Row(s) that you are interested in and finally the Item
(column/field) of that row.

Since the DataSet is a disconnected copy of the resultset, you can access
its data at any time throughout your code after you populate it.

-Scott

"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:F1**********************************@microsof t.com...
>I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For
example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.

Dec 7 '07 #2
Kelly,
A good place to start for all this "Stuff" is the QUICKSTARTS tutorials
which installs with either Visual Studio or the .NET Framework SDK, or you
can use the online version at the ASP.NET Site:
http://quickstarts.asp.net/QuickStartv20/default.aspx

I don't want to sound like a broken MP3, but really - I've been doing .NET
since the first beta in 2000, and I still use the QUICKSTARTS today.
-- Peter
http://www.eggheadcafe.com
http://petesbloggerama.blogspot.com
http://www.blogmetafinder.com
"Kelly" wrote:
I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.
Dec 8 '07 #3
On 7 Dec, 22:21, Kelly <Ke...@discussions.microsoft.comwrote:
I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.
I am inclined to agree with Peter Bromberg. As a piece of advice to
all former ASP programmers. Don't assume that ASP.NET is and extention
of ASP it isn't! It's a completely different platform.

The real underlying innovation is in Framework which draws together
experience from a variety of technologies and source languages. It's
great but it does require a lot of fresh learning from the developers
point of view.

Dec 8 '07 #4
Assuming firstname was the first item from the first row in the first
datatable in your dataset.
<%= mydataset.tables(0).rows(0).item(0)%>
or
<%= mydataset.tables(0).rows(1).item("firstname")%will for example return
an item called firstname from the 2nd row in the 1st datatable in your
dataset

Binding in asp.net isn't the same as calling details from a recordset as
recordsets only had one result set in, where a dataset in asp.net can have
many tabels and results.

So, you would be better off executing code (in page_load for example) to
populate a string, int etc. and then binding to that in each of your
controls either as code in the method label1.text =
mydataset.tables(0).rows(0).item(0), or as <% =firstname %inline. Inline
code is not the recommended approach, even if the other way sometimes takes
more code.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:F1**********************************@microsof t.com...
>I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For
example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.

Dec 8 '07 #5
Thanks, Scott. But what I want to achieve is to build my own html table and
have the data populated into the cells. I know there are data bound controls
to use, such as gridview, repeater, etc. But they cannot be freely modified
as I want, it seems to me. For example, if I want to populate the stuff from
2 data sources into 1 html table, gridview, repeater controls won't work for
me. I am looking for .net equivalent to <%=recordset("firstname")%>. Is
that such a thing available?

"Scott M." wrote:
Well, that question is actually a bit more complicated now, since in ASP
..NET and ADO .NET, we don't have recordsets any more.

If you are looking for a connected, read-only, and forward-only way of
iterating over your results, you can use a DataReader once you've executed
your command and then loop through it so you can see your returned records
one by one.

If you need to persist your data a bit longer than this, or if you need to
be able to back up through the records, ADO .NET provides us with a DataSet
(which is like an in memory relational database). A DataSet is disconnected
from the source of the data so, you can access your data at any time after
populating your DataSet by accessing the table(s) of data that it contains
and then the Row(s) that you are interested in and finally the Item
(column/field) of that row.

Since the DataSet is a disconnected copy of the resultset, you can access
its data at any time throughout your code after you populate it.

-Scott

"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:F1**********************************@microsof t.com...
I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For
example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.


Dec 8 '07 #6
This is exactly what I want. Thanks.

"John Timney (MVP)" wrote:
Assuming firstname was the first item from the first row in the first
datatable in your dataset.
<%= mydataset.tables(0).rows(0).item(0)%>
or
<%= mydataset.tables(0).rows(1).item("firstname")%will for example return
an item called firstname from the 2nd row in the 1st datatable in your
dataset

Binding in asp.net isn't the same as calling details from a recordset as
recordsets only had one result set in, where a dataset in asp.net can have
many tabels and results.

So, you would be better off executing code (in page_load for example) to
populate a string, int etc. and then binding to that in each of your
controls either as code in the method label1.text =
mydataset.tables(0).rows(0).item(0), or as <% =firstname %inline. Inline
code is not the recommended approach, even if the other way sometimes takes
more code.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:F1**********************************@microsof t.com...
I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For
example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.


Dec 8 '07 #7
Again Kelly, I'll refer you to my first post.

If you want to be able to access the data anywhere in your page response,
you'll need to store it...and that means a Dataset. Then, you can dig into
that DataSet and extract what you want, when you want.

-Scott

"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:99**********************************@microsof t.com...
Thanks, Scott. But what I want to achieve is to build my own html table
and
have the data populated into the cells. I know there are data bound
controls
to use, such as gridview, repeater, etc. But they cannot be freely
modified
as I want, it seems to me. For example, if I want to populate the stuff
from
2 data sources into 1 html table, gridview, repeater controls won't work
for
me. I am looking for .net equivalent to <%=recordset("firstname")%>. Is
that such a thing available?

"Scott M." wrote:
>Well, that question is actually a bit more complicated now, since in ASP
..NET and ADO .NET, we don't have recordsets any more.

If you are looking for a connected, read-only, and forward-only way of
iterating over your results, you can use a DataReader once you've
executed
your command and then loop through it so you can see your returned
records
one by one.

If you need to persist your data a bit longer than this, or if you need
to
be able to back up through the records, ADO .NET provides us with a
DataSet
(which is like an in memory relational database). A DataSet is
disconnected
from the source of the data so, you can access your data at any time
after
populating your DataSet by accessing the table(s) of data that it
contains
and then the Row(s) that you are interested in and finally the Item
(column/field) of that row.

Since the DataSet is a disconnected copy of the resultset, you can access
its data at any time throughout your code after you populate it.

-Scott

"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:F1**********************************@microso ft.com...
>I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For
example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.



Dec 9 '07 #8
Gee, I thought that's what I said.

"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:76**********************************@microsof t.com...
This is exactly what I want. Thanks.

"John Timney (MVP)" wrote:
>Assuming firstname was the first item from the first row in the first
datatable in your dataset.
<%= mydataset.tables(0).rows(0).item(0)%>
or
<%= mydataset.tables(0).rows(1).item("firstname")%will for example
return
an item called firstname from the 2nd row in the 1st datatable in your
dataset

Binding in asp.net isn't the same as calling details from a recordset as
recordsets only had one result set in, where a dataset in asp.net can
have
many tabels and results.

So, you would be better off executing code (in page_load for example) to
populate a string, int etc. and then binding to that in each of your
controls either as code in the method label1.text =
mydataset.tables(0).rows(0).item(0), or as <% =firstname %inline.
Inline
code is not the recommended approach, even if the other way sometimes
takes
more code.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:F1**********************************@microso ft.com...
>I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For
example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it in
asp.net?

Sorry for the simple question, but please help.



Dec 9 '07 #9
It was - I just converted it into beginner speak......lol

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"Scott M." <sm**@nospam.nospamwrote in message
news:uO*************@TK2MSFTNGP06.phx.gbl...
Gee, I thought that's what I said.

"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:76**********************************@microsof t.com...
>This is exactly what I want. Thanks.

"John Timney (MVP)" wrote:
>>Assuming firstname was the first item from the first row in the first
datatable in your dataset.
<%= mydataset.tables(0).rows(0).item(0)%>
or
<%= mydataset.tables(0).rows(1).item("firstname")%will for example
return
an item called firstname from the 2nd row in the 1st datatable in your
dataset

Binding in asp.net isn't the same as calling details from a recordset as
recordsets only had one result set in, where a dataset in asp.net can
have
many tabels and results.

So, you would be better off executing code (in page_load for example) to
populate a string, int etc. and then binding to that in each of your
controls either as code in the method label1.text =
mydataset.tables(0).rows(0).item(0), or as <% =firstname %inline.
Inline
code is not the recommended approach, even if the other way sometimes
takes
more code.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog
"Kelly" <Ke***@discussions.microsoft.comwrote in message
news:F1**********************************@micros oft.com...
I am from classic asp and learning asp.net. In the past, once I have a
recordset retrieved, I can use it wheneve and wherever I want. For
example,
I know my recordset contains something like rs("firstname"), I can do
<%=rs("firstname")%anywhere in the web page. How do we achieve it
in
asp.net?

Sorry for the simple question, but please help.


Dec 9 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Patchwork | last post by:
Hi Everyone, Please take a look at the following (simple and fun) program: //////////////////////////////////////////////////////////////////////////// ///////////// // Monster Munch, example...
1
by: Proteus | last post by:
Any help appreciated on a small perl project I need to write for educator/teaching purposes. I have not programmed perl for some time, need to get up to speed, maybe some kind souls hrere will help...
2
by: Raskolnikow | last post by:
Hi! I have a very simple problem with itoa() or the localtime(...). Sorry, if it is too simple, I don't have a proper example. Please have a look at the comments. struct tm *systime; time_t...
3
by: Peter | last post by:
Hello Thanks for reviewing my question. I would like to know how can I programmatically select a node Thanks in Advanc Peter
7
by: abcd | last post by:
I am trying to set up client machine and investigatging which .net components are missing to run aspx page. I have a simple aspx page which just has "hello world" printed.... When I request...
4
by: dba_222 | last post by:
Dear Experts, Ok, I hate to ask such a seemingly dumb question, but I've already spent far too much time on this. More that I would care to admit. In Sql server, how do I simply change a...
14
by: Giancarlo Berenz | last post by:
Hi: Recently i write this code: class Simple { private: int value; public: int GiveMeARandom(void);
30
by: galiorenye | last post by:
Hi, Given this code: A** ppA = new A*; A *pA = NULL; for(int i = 0; i < 10; ++i) { pA = ppA; //do something with pA
10
by: Phillip Taylor | last post by:
Hi guys, I'm looking to develop a simple web service in VB.NET but I'm having some trivial issues. In Visual Studio I create a web services project and change the asmx.vb file to this: Imports...
17
by: Chris M. Thomasson | last post by:
I use the following technique in all of my C++ projects; here is the example code with error checking omitted for brevity: _________________________________________________________________ /*...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.