473,327 Members | 2,074 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,327 software developers and data experts.

What if <itemtemplate> does correlate to 1 row in dataset?

I am trying to build a custom crosstab type of grid where I take some items
in a data grid and based on the content of the current item compared to the
previous item, determine if a new row in a table should be created or not.
In order to do this, I need to have full control over the conditional logic
for how items get displayed within a repeater element which I'm not seeing
as possible.

How can I cursor through a data set, apply conditional logic to it as I do
to customize how it is outputed to the screen? The repeater, datagrid and
data list seem great if your query comes back in a table structure where
each record correlates to an item, but if you have 10 records that relate to
a single "item" then I'm lost on how to get it to look like 1 item.

Thanks,
Ben

Nov 18 '05 #1
3 2024
You don't tell us if you're using ADO.NET - so I'll assume you are because
that would make a lot of sense in .NET programming. If you're not using
ADO.NET, then you should tell us what you are using...

<<<How can I cursor through a data set, >>>
You don't - at least not in the traditional sense of a "cursor" (MoveNext,
MovePrior, Move N are just not part of the ADO.NET game). Rather the ADO.NET
DataSet is comprised of a collection of DataRow objects - so you navigate
through the collection just like you'd navigate any other collection.

The Datagrid, datalist, and repeater are generally designed to be bound to
something (e.g, DataTable) that pretty much already contains what needs to
be presented in the UI. So, one of your options is this:
1. Create a brand new and empty DataTable (or DataSet) in your code (create
it out of thin air - this is not your grand father's ADO). Your complicated
custom logic can add new DataRow objects as necessary. So, the sequence of
events would be something like this: (1) you retrieve your initial DataSet
("uncross-tabbed" data) from your data source, and (2) run it through your
custom logic - which (3) outputs a new DataSet/DataTable. You then (4) bind
your repeater control (DataList, DataGrid, DataRepeater) to the output
DataSet/DataTable.

Jeff

"Ben Becker" <be*@benbecker.net> wrote in message
news:uZ**************@TK2MSFTNGP10.phx.gbl...
I am trying to build a custom crosstab type of grid where I take some items in a data grid and based on the content of the current item compared to the previous item, determine if a new row in a table should be created or not.
In order to do this, I need to have full control over the conditional logic for how items get displayed within a repeater element which I'm not seeing
as possible.

How can I cursor through a data set, apply conditional logic to it as I do
to customize how it is outputed to the screen? The repeater, datagrid and
data list seem great if your query comes back in a table structure where
each record correlates to an item, but if you have 10 records that relate to a single "item" then I'm lost on how to get it to look like 1 item.

Thanks,
Ben

Nov 18 '05 #2
Thank you for the reply. Yes, I am using ADO.NET and I think I understand
what you are saying. The repeater wants it already formatted so if it
isn't, I'll have to build a custom data set and then bind it to the repeater
(or even the data grid for that matter since it should suffice).

Thank you again for the quick reply!
Ben

"Jeff" <A@B.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
You don't tell us if you're using ADO.NET - so I'll assume you are because
that would make a lot of sense in .NET programming. If you're not using
ADO.NET, then you should tell us what you are using...

<<<How can I cursor through a data set, >>>
You don't - at least not in the traditional sense of a "cursor" (MoveNext,
MovePrior, Move N are just not part of the ADO.NET game). Rather the ADO.NET DataSet is comprised of a collection of DataRow objects - so you navigate
through the collection just like you'd navigate any other collection.

The Datagrid, datalist, and repeater are generally designed to be bound to
something (e.g, DataTable) that pretty much already contains what needs to
be presented in the UI. So, one of your options is this:
1. Create a brand new and empty DataTable (or DataSet) in your code (create it out of thin air - this is not your grand father's ADO). Your complicated custom logic can add new DataRow objects as necessary. So, the sequence of
events would be something like this: (1) you retrieve your initial DataSet
("uncross-tabbed" data) from your data source, and (2) run it through your
custom logic - which (3) outputs a new DataSet/DataTable. You then (4) bind your repeater control (DataList, DataGrid, DataRepeater) to the output
DataSet/DataTable.

Jeff

"Ben Becker" <be*@benbecker.net> wrote in message
news:uZ**************@TK2MSFTNGP10.phx.gbl...
I am trying to build a custom crosstab type of grid where I take some items
in a data grid and based on the content of the current item compared to

the
previous item, determine if a new row in a table should be created or not. In order to do this, I need to have full control over the conditional

logic
for how items get displayed within a repeater element which I'm not seeing as possible.

How can I cursor through a data set, apply conditional logic to it as I do to customize how it is outputed to the screen? The repeater, datagrid and data list seem great if your query comes back in a table structure where
each record correlates to an item, but if you have 10 records that

relate to
a single "item" then I'm lost on how to get it to look like 1 item.

Thanks,
Ben


Nov 18 '05 #3
<<<I'll have to build a custom data set and then bind it to the repeater
(or even the data grid for that matter since it should suffice)>>>
Exactly. And I'll add that if the data is read-only (which cross-tab data
inherently is), then you might want to use a Repeater or DataList control
rather than a DataGrid - reason being that the DataGrid is not as
light-weight as the Repeater or DataList, and you won't need all the
features possible in the DataGrid. You bind to a DataList or Repeater just
as you would a DataGrid.
For assistance in chosing how to best display your cross-tab DataSet, check
out the following link:
http://msdn.microsoft.com/library/de...ebcontrols.asp

What you will most likely *not* be doing is programmatically adding a new
row to the grid, and then assigning cell values (as was the case with some
of the old COM grids in Windows Client applications (ah, those were the
days!). In the new world you prepare your data in a clean DataSet or
DataTable, behind the scenes, and then bind to whatever control will be
displaying it.

Good Luck.


"Ben Becker" <be*@benbecker.net> wrote in message
news:OJ**************@TK2MSFTNGP12.phx.gbl... Thank you for the reply. Yes, I am using ADO.NET and I think I understand
what you are saying. The repeater wants it already formatted so if it
isn't, I'll have to build a custom data set and then bind it to the repeater (or even the data grid for that matter since it should suffice).

Thank you again for the quick reply!
Ben

"Jeff" <A@B.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
You don't tell us if you're using ADO.NET - so I'll assume you are because
that would make a lot of sense in .NET programming. If you're not using
ADO.NET, then you should tell us what you are using...

<<<How can I cursor through a data set, >>>
You don't - at least not in the traditional sense of a "cursor" (MoveNext, MovePrior, Move N are just not part of the ADO.NET game). Rather the ADO.NET
DataSet is comprised of a collection of DataRow objects - so you navigate through the collection just like you'd navigate any other collection.

The Datagrid, datalist, and repeater are generally designed to be bound to something (e.g, DataTable) that pretty much already contains what needs to be presented in the UI. So, one of your options is this:
1. Create a brand new and empty DataTable (or DataSet) in your code

(create
it out of thin air - this is not your grand father's ADO). Your

complicated
custom logic can add new DataRow objects as necessary. So, the sequence of events would be something like this: (1) you retrieve your initial DataSet ("uncross-tabbed" data) from your data source, and (2) run it through your custom logic - which (3) outputs a new DataSet/DataTable. You then (4)

bind
your repeater control (DataList, DataGrid, DataRepeater) to the output
DataSet/DataTable.

Jeff

"Ben Becker" <be*@benbecker.net> wrote in message
news:uZ**************@TK2MSFTNGP10.phx.gbl...
I am trying to build a custom crosstab type of grid where I take some

items
in a data grid and based on the content of the current item compared to
the
previous item, determine if a new row in a table should be created or

not. In order to do this, I need to have full control over the conditional

logic
for how items get displayed within a repeater element which I'm not seeing as possible.

How can I cursor through a data set, apply conditional logic to it as
I do to customize how it is outputed to the screen? The repeater, datagrid and data list seem great if your query comes back in a table structure

where each record correlates to an item, but if you have 10 records that

relate
to
a single "item" then I'm lost on how to get it to look like 1 item.

Thanks,
Ben



Nov 18 '05 #4

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

Similar topics

0
by: Andla Rand | last post by:
Hi, I would like to use this feature but in the codebehind. I'm reading from an example text and everything is not codebehind. I would appreciate if you could help me on this. <form...
0
by: Mehdi | last post by:
Hi, I have a datagrid which is populated by a dataset. I have a column containing LinkButton that passes MyID and fires my event handler... .... <ItemTemplate> <asp:LinkButton id="btnEdit"...
7
by: David Laub | last post by:
I have stumbled across various Netscape issues, none of which appear to be solvable by tweaking the clientTarget or targetSchema properties. At this point, I'm not even interested in "solving"...
4
by: z. f. | last post by:
Hi, I'm having an aspx page with a server form. i have a grid with a delete button and below the grid, another area with inputs for inserting new values and an "add" button for submiting the...
1
by: Jesper Pedersen | last post by:
Hi ! How do I access the following spillerID and Session from another *aspx page in my application? <ItemTemplate> <a href="player_details.aspx?spillerID=<%#...
3
by: webserverpete | last post by:
I would like to have multiple <td> in a repeater control. The below code does not work: <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1" DataMember="DefaultView">...
3
by: | last post by:
I have been researching articles on google on how to create a simple RSS feed that sucks <title><blurb><link><date> out of a sql server 2000 database via an aspx page. I know it has to be pushed...
3
by: Opa | last post by:
Hi, I have and XMLDataSource which I am using in a GridView control and am customizing the grid with <ItemTemplate>. My XML datasource has an element with an attribute called "private". I want...
5
by: Jim in Arizona | last post by:
How do I find a control within a datalist itemtemplate from a sub procedure that isn't a normal called procedure from a datalist (like the update, edit, or cancel procedures)? For instance,...
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
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...

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.