Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > How to design a drill-down grid ?

Reply
Thread Tools

How to design a drill-down grid ?

 
 
Bjorn Sagbakken
Guest
Posts: n/a
 
      10-10-2007
I should very much like to add a sophisticated drill-down feature to a
grid/table in our ASP.NET web pages (VS 2005), sort of like the funtionality
of the treeview. But I want the presentation to be as with a table with
columns and rows in different style/color for each indented drill-down step
(sub-tables).

An example would be a table of customers, but with a click on the + sign on
the left edge one can view a sub-table with all orders for a single
customer. Next, click on the + sign for a single order to view a new
sub-table containing the items on the order.

Is this possible? And what is the best approach?

Bjorn


 
Reply With Quote
 
 
 
 
Alvin Bruney [MVP]
Guest
Posts: n/a
 
      10-11-2007
It's very straightforward and easily accomplished. You will simply need to
handle the drill/click event and fire a query at the data with an updated
where clause containing the row item that you need to drill on.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless Author Plug
OWC Black Book 2nd Edition
Exclusively on www.lulu.com/owc
$24.99


"Bjorn Sagbakken" <bjo-> wrote in message
news...
>I should very much like to add a sophisticated drill-down feature to a
>grid/table in our ASP.NET web pages (VS 2005), sort of like the
>funtionality of the treeview. But I want the presentation to be as with a
>table with columns and rows in different style/color for each indented
>drill-down step (sub-tables).
>
> An example would be a table of customers, but with a click on the + sign
> on the left edge one can view a sub-table with all orders for a single
> customer. Next, click on the + sign for a single order to view a new
> sub-table containing the items on the order.
>
> Is this possible? And what is the best approach?
>
> Bjorn
>



 
Reply With Quote
 
 
 
 
Bjorn Sagbakken
Guest
Posts: n/a
 
      10-11-2007
Yes, the database query is easy, but whitch grid/table component should be
used to present a dynamical table within a table within a table...

Bjorn

"Alvin Bruney [MVP]" <some guy without an email address> wrote in message
news:...
> It's very straightforward and easily accomplished. You will simply need to
> handle the drill/click event and fire a query at the data with an updated
> where clause containing the row item that you need to drill on.
>
> --
> Regards,
> Alvin Bruney
> ------------------------------------------------------
> Shameless Author Plug
> OWC Black Book 2nd Edition
> Exclusively on www.lulu.com/owc
> $24.99
>
>
> "Bjorn Sagbakken" <bjo-> wrote in message
> news...
>>I should very much like to add a sophisticated drill-down feature to a
>>grid/table in our ASP.NET web pages (VS 2005), sort of like the
>>funtionality of the treeview. But I want the presentation to be as with a
>>table with columns and rows in different style/color for each indented
>>drill-down step (sub-tables).
>>
>> An example would be a table of customers, but with a click on the + sign
>> on the left edge one can view a sub-table with all orders for a single
>> customer. Next, click on the + sign for a single order to view a new
>> sub-table containing the items on the order.
>>
>> Is this possible? And what is the best approach?
>>
>> Bjorn
>>

>
>



 
Reply With Quote
 
IfThenElse
Guest
Posts: n/a
 
      10-11-2007
Third party component, create your own or Google there are few free ones.

I will take you a while or some effort to learn how to use them however.



"Bjorn Sagbakken" <bjo-> wrote in message
news:I-...
> Yes, the database query is easy, but whitch grid/table component should be
> used to present a dynamical table within a table within a table...
>
> Bjorn
>
> "Alvin Bruney [MVP]" <some guy without an email address> wrote in message
> news:...
>> It's very straightforward and easily accomplished. You will simply need
>> to handle the drill/click event and fire a query at the data with an
>> updated where clause containing the row item that you need to drill on.
>>
>> --
>> Regards,
>> Alvin Bruney
>> ------------------------------------------------------
>> Shameless Author Plug
>> OWC Black Book 2nd Edition
>> Exclusively on www.lulu.com/owc
>> $24.99
>>
>>
>> "Bjorn Sagbakken" <bjo-> wrote in message
>> news...
>>>I should very much like to add a sophisticated drill-down feature to a
>>>grid/table in our ASP.NET web pages (VS 2005), sort of like the
>>>funtionality of the treeview. But I want the presentation to be as with a
>>>table with columns and rows in different style/color for each indented
>>>drill-down step (sub-tables).
>>>
>>> An example would be a table of customers, but with a click on the + sign
>>> on the left edge one can view a sub-table with all orders for a single
>>> customer. Next, click on the + sign for a single order to view a new
>>> sub-table containing the items on the order.
>>>
>>> Is this possible? And what is the best approach?
>>>
>>> Bjorn
>>>

>>
>>

>
>



 
Reply With Quote
 
Bjorn Sagbakken
Guest
Posts: n/a
 
      10-11-2007
Ok, that was useful information.

Bjorn

"IfThenElse" <> wrote in message
news:ur%23%...
> Third party component, create your own or Google there are few free ones.
>
> I will take you a while or some effort to learn how to use them however.
>
>
>
> "Bjorn Sagbakken" <bjo-> wrote in message
> news:I-...
>> Yes, the database query is easy, but whitch grid/table component should
>> be used to present a dynamical table within a table within a table...
>>
>> Bjorn
>>
>> "Alvin Bruney [MVP]" <some guy without an email address> wrote in message
>> news:...
>>> It's very straightforward and easily accomplished. You will simply need
>>> to handle the drill/click event and fire a query at the data with an
>>> updated where clause containing the row item that you need to drill on.
>>>
>>> --
>>> Regards,
>>> Alvin Bruney
>>> ------------------------------------------------------
>>> Shameless Author Plug
>>> OWC Black Book 2nd Edition
>>> Exclusively on www.lulu.com/owc
>>> $24.99
>>>
>>>
>>> "Bjorn Sagbakken" <bjo-> wrote in message
>>> news...
>>>>I should very much like to add a sophisticated drill-down feature to a
>>>>grid/table in our ASP.NET web pages (VS 2005), sort of like the
>>>>funtionality of the treeview. But I want the presentation to be as with
>>>>a table with columns and rows in different style/color for each indented
>>>>drill-down step (sub-tables).
>>>>
>>>> An example would be a table of customers, but with a click on the +
>>>> sign on the left edge one can view a sub-table with all orders for a
>>>> single customer. Next, click on the + sign for a single order to view a
>>>> new sub-table containing the items on the order.
>>>>
>>>> Is this possible? And what is the best approach?
>>>>
>>>> Bjorn
>>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
Grouped grid? Or grid within datalist? Danny Tuppeny ASP .Net 1 10-27-2005 10:03 PM
How to transfer a value from an Invisible Grid to an visible Grid =?Utf-8?B?QXNzYW5LaGFuIElzbWFpbA==?= ASP .Net 2 10-17-2005 03:56 AM
Grid within a Grid ItemDataBound event problem Girish ASP .Net 4 07-19-2005 01:17 AM
Grid question: How do I force grid elements to expand and use available space Marc Python 0 10-08-2003 05:06 PM



Advertisments