Display data with ASP.NET

[seth_hickel]

With other solutions I would get a recordset, read each record and
display data by formating my html as I wanted to display values of
each record. I am trying to display data in a three column three row
table with paging. How does this translate to ASP.NET - or - what
ASP.NET tools do I use to accomplish this and how.

Thank you.

[Mark Rae]

<se*********@yahoo.comwrote in message
news:11*********************@y5g2000hsa.googlegrou ps.com...

With other solutions I would get a recordset, read each record and
display data by formating my html as I wanted to display values of
each record. I am trying to display data in a three column three row
table with paging. How does this translate to ASP.NET - or - what
ASP.NET tools do I use to accomplish this and how.

There's nothing to stop you doing exactly this in ASP.NET if you want to...
The only difference is that ASP.NET uses ADO.NET natively (since it's part
of the Framework), not ADO...

The ADO.NET equivalent of an ADO Recordset is (more or less) the DataSet
object. It has a collection of tables, and each table has a collection of
rows etc...

However, ASP.NET has databound controls e.g. <asp:GridViewwhich accept an
ADO.NET object such as a DataSet as their DataSource property - this means
that most of the ASP Classic "donkey work" is removed.

Do a Google search for ASP.NET DataSet <asp:GridView>

[sloan]

#1 Rule with Asp.Net

DO NOT LOOP OVER RECORDS TO CREATE HTML.

Here is a decent place to start.

http://www.asp101.com/samples/database_aspx.asp
Notice the use of
..DataSource = (some object)
..DataBind()
DO NOT LOOP OVER ITEMS AND CREATE HTML.
I would look at the
asp:repeater control.

<se*********@yahoo.comwrote in message
news:11*********************@y5g2000hsa.googlegrou ps.com...

With other solutions I would get a recordset, read each record and
display data by formating my html as I wanted to display values of
each record. I am trying to display data in a three column three row
table with paging. How does this translate to ASP.NET - or - what
ASP.NET tools do I use to accomplish this and how.

Thank you.

[seth_hickel]

Thank you for the helpful response.

OK - I like the fact that <asp:GridViewmakes life easier with
things like "AllowPaging = "True"" and "AllowSorting = "True"".

But I still am not sure how to control the display of my data.
Example: I want to use a the value of my ProductID field to build an
image URL and display it in a <tr><td></td></tr>. Then in a new row I
want to use the value of my ProductDescription field to display text,
and etc ...

It appears that <asp:GridViewdisplays all field data returned from
the query and displays it in a simple table view. Am I missing
something?

Should I be using another asp construct for my purpose?
On Apr 20, 10:10 am, "Mark Rae" <[e-mail]:

<[e-mail] in message

news:11*********************@y5g2000hsa.googlegrou ps.com...

With other solutions I would get a recordset, read each record and
display data by formating my html as I wanted to display values of
each record. I am trying to display data in a three column three row
table with paging. How does this translate to ASP.NET - or - what
ASP.NET tools do I use to accomplish this and how.

There's nothing to stop you doing exactly this in ASP.NET if you want to...
The only difference is that ASP.NET uses ADO.NET natively (since it's part
of the Framework), not ADO...

The ADO.NET equivalent of an ADO Recordset is (more or less) the DataSet
object. It has a collection of tables, and each table has a collection of
rows etc...

However, ASP.NET has databound controls e.g. <asp:GridViewwhich accept an
ADO.NET object such as a DataSet as their DataSource property - this means
that most of the ASP Classic "donkey work" is removed.

Do a Google search for ASP.NET DataSet <asp:GridView>

[seth_hickel]

I should also mention that I am trying to create a page with three
rows of three table cells each.

On Apr 20, 4:34 pm, [e-mail] wrote:

Thank you for the helpful response.

OK - I like the fact that <asp:GridViewmakes life easier with
things like "AllowPaging = "True"" and "AllowSorting = "True"".

But I still am not sure how to control the display of my data.
Example: I want to use a the value of my ProductID field to build an
image URL and display it in a <tr><td></td></tr>. Then in a new row I
want to use the value of my ProductDescription field to display text,
and etc ...

It appears that <asp:GridViewdisplays all field data returned from
the query and displays it in a simple table view. Am I missing
something?

Should I be using another asp construct for my purpose?

On Apr 20, 10:10 am, "Mark Rae" <[e-mail]:

<[e-mail] in message

news:11*********************@y5g2000hsa.googlegrou ps.com...

With other solutions I would get a recordset, read each record and
display data by formating my html as I wanted to display values of
each record. I am trying to display data in a three column three row
table with paging. How does this translate to ASP.NET - or - what
ASP.NET tools do I use to accomplish this and how.

There's nothing to stop you doing exactly this in ASP.NET if you want to...
The only difference is that ASP.NET uses ADO.NET natively (since it's part
of the Framework), not ADO...

The ADO.NET equivalent of an ADO Recordset is (more or less) the DataSet
object. It has a collection of tables, and each table has a collection of
rows etc...

However, ASP.NET has databound controls e.g. <asp:GridViewwhich accept an
ADO.NET object such as a DataSet as their DataSource property - this means
that most of the ASP Classic "donkey work" is removed.

Do a Google search for ASP.NET DataSet <asp:GridView>- Hide quoted text -

- Show quoted text -