Home All Groups Group Topic Archive Search About
Author
14 Mar 2006 6:59 AM
JDP@Work
I'm looking for VB.Net snipits/links to managing scrolling datagrids with a
fixed header where I don't know the number or column labels, these may be
generated dynamically, I can set the widths at design time.

For some columns, I may be using ItemTemplate and setting the label value at
runtime or design time.

TIA

JeffP...

Author
14 Mar 2006 10:53 AM
CaffieneRush@gmail.com
I take it that you've seen Paul Kimmel's article below for a fixed
header gridview (it should also apply to datagrid):
http://www.developer.com/net/asp/article.php/3585911

You can create the fixed headers within the scroll panel to match the
column labels of your datagrid.
Two things to be aware of: the built in header sorting functionality of
GridView is lost with this technique + controlling the widths of each
header field to match the gridview fields is difficult (perhaps my
HTML/CSS skills are not up to standard).

Good luck.
Author
14 Mar 2006 5:23 PM
JDP@Work
<CaffieneR***@gmail.com> wrote in message
Show quoteHide quote
news:1142333596.360019.220090@u72g2000cwu.googlegroups.com...
> I take it that you've seen Paul Kimmel's article below for a fixed
> header gridview (it should also apply to datagrid):
> http://www.developer.com/net/asp/article.php/3585911
>
> You can create the fixed headers within the scroll panel to match the
> column labels of your datagrid.
> Two things to be aware of: the built in header sorting functionality of
> GridView is lost with this technique + controlling the widths of each
> header field to match the gridview fields is difficult (perhaps my
> HTML/CSS skills are not up to standard).
>
> Good luck.
>

Yes, I noticed this technique on a few sites, but I do need to be able to sort.

What I'm doing is creating a "report" style page that I hope to abstract into
my.vb all the generic dg functions such as subtotals as number or currency,
grand totals the same.

I had hoped to be able to put in a fixed header and scrolling as needed using
functions like (sis-eh-Fi)

"Private Sub cssifFy_dg (dg byVal, head as Array, cssStyle as string)"

The head array is colum ordinal number and sorting as

Colum 3, sort = true as "31"

I would call cssifFy_dg from a case stmt by view or panel ID

I'm already doing this for my table columns to know which to subtotal (insert a
subtotal row/item) and to format it as currency or number and then if it does
have subtotals to correctly process the footer Grand totals.

I further control this from SQL, my dg knows which columns to total when a
column in the data set is prefaced with a "t_" as StaffCount returned as
t_StaffCount will now subtotal.

The dg doesn't know anything about the column header text value or similar that
is all set at runtime.

Then when the client says, hey can you add a subtotal to that column, Yes,
modify the SQL sProc, a viola subtotals, sans a new .Net build!

This is real handy when I have to get any new .Net builds approved and emailed
and installed by someone else at the client site, this can take days or weeks to
do.

Rather, than my current way which takes minutes and only a minor tweak to the
SQL which I almost always have access to.

HTH

Still searching for that perfect dg in 1.1, most clients have not updated to
..Net 2x and I don't control that process.

TIA

JeffP.....