DataGridView footer

[=?Utf-8?B?VmFuZXNzYQ==?=]

Hi all,

How can I display a footer in a DataGridView?

Thank you in advance,
Vanessa

[Nicholas Paldino [.NET/C# MVP]]

Vanessa,

You can't. You would have to custom paint the control and add the
footer (no small task, by any means). You are better off with a third-party
control that does this, or create your own control which will be displayed
below the DataGridView.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Vanessa" <Va*****@discussions.microsoft.comwrote in message
news:A2**********************************@microsof t.com...

Hi all,

How can I display a footer in a DataGridView?

Thank you in advance,
Vanessa

[=?Utf-8?B?VmFuZXNzYQ==?=]

Thank you!

Well, what I need is to sum some columns and put the total in the last row.
If I add a row with the total, how can I prevent it to not participate in the
sort?

Thanks in advance!
Vanessa

"Nicholas Paldino [.NET/C# MVP]" wrote:

Vanessa,

You can't. You would have to custom paint the control and add the
footer (no small task, by any means). You are better off with a third-party
control that does this, or create your own control which will be displayed
below the DataGridView.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Vanessa" <Va*****@discussions.microsoft.comwrote in message
news:A2**********************************@microsof t.com...

Hi all,

How can I display a footer in a DataGridView?

Thank you in advance,
Vanessa

[Greg]

On Jan 7, 9:44*am, Vanessa <[e-mail]:

Hi all,

How can I display a footer in a DataGridView?

Thank you in advance,
Vanessa

Painting it is your best bet. I extended a ListView control to have a
footer and header. The footer was a summation of records as well as
the controls to allow for paging large records.

cheers
Greg

[Marc Gravell]

How are you putting the data in the DataGridView? Are you binding to
an existing list? If so, you might be able to influence the sort
behavior by providing a custom sort implementation. If this is a
DataTable it would be harder...

Marc

[=?Utf-8?B?VmFuZXNzYQ==?=]

Hi Marc!

I binding via dataview of a dataset table.

Thanks
Vanessa

"Marc Gravell" wrote:

How are you putting the data in the DataGridView? Are you binding to
an existing list? If so, you might be able to influence the sort
behavior by providing a custom sort implementation. If this is a
DataTable it would be harder...

Marc

[=?Utf-8?B?VmFuZXNzYQ==?=]

Hi Greg!

Do you have an example on how can I do this?

Thanks
Vanessa

"Greg" wrote:

On Jan 7, 9:44 am, Vanessa <[e-mail]:

Hi all,

How can I display a footer in a DataGridView?

Thank you in advance,
Vanessa

Painting it is your best bet. I extended a ListView control to have a
footer and header. The footer was a summation of records as well as
the controls to allow for paging large records.

cheers
Greg

[Marc Gravell]

Damn; that makes this a pain... I'll see if I can come up with
something later? (busy at the mo...)

Marc

[=?Utf-8?B?VmFuZXNzYQ==?=]

Hi Marc,

Thank you and I will wait for your help!

Vanessa

"Marc Gravell" wrote:

Damn; that makes this a pain... I'll see if I can come up with
something later? (busy at the mo...)

Marc

[Marc Gravell]

I got something working by having a dummy (hidden) column to indicate
whether it is a footer row or not (well, actually it just uses a
hidden preliminary sort, so it would also work for headers etc)...
It works by hiding an extra (first) sort in IBindingList and
IBindingListView... it has to be hidden for the reversal to work
properly.
here is the usage example; I'll post the implementation
(CustomDataView) in a second post (it's a bit long... but most of it
was auto-generated)

static void Main() {
Application.EnableVisualStyles();
// declare table
DataTable dt = new DataTable("Test");
dt.Columns.Add("IsFooter", typeof(bool));
dt.Columns.Add("Caption", typeof(string));
dt.Columns.Add("Value", typeof(int));
// fill with some random data
Random rand = new Random();
int sum = 0;
for (int i = 0; i < 20; i++) {
int val = rand.Next(50);
dt.Rows.Add(false, "Row " + i.ToString(), val);
sum += val;
}
// add footer row
dt.Rows.Add(true, "Total", sum);

// display
using(Form form = new Form())
using (DataGridView grid = new DataGridView()) {
grid.Dock = DockStyle.Fill;
grid.AllowUserToAddRows = false;
form.Controls.Add(grid);
grid.DataSource = new CustomDataView(dt.DefaultView,
"IsFooter", ListSortDirection.Ascending);
grid.Columns[0].Visible = false;
Application.Run(form);
}
}

[Marc Gravell]

Thank you very much! It worked in a sample, so I will adapt it into

my project.

You're welcome; if you get any problems, post back ;-p

Best of luck, Marc

[Marc Gravell]

I don't think it would be simple to apply paging using a filter; in
particular, the code for adding/removing items (at the bottom of the
DataGridView) would be a real pain. As it happens I do have a
(predicate-oriented) filtered-list implementation up my sleeve, but I
don't think it is a good fit for what you are doing...

Being pragmatic, for paging, would it not be easier to simply copy the
page that you want from your original list into the data-bound list?

(This is what you have suggested in the last discussion)

Did I? I don't remember that, and can't see it in the archive...

For info, this discussion was really about sorting, not filtering;
they are very different beasts...

If you are paging over a very large result, consider also "virtual
mode".

Marc