how to freeze a row and keep it at the bottom of the gridbounddatagrid

[Charlie Mao]

does anyone know how to freeze a row and keep it at the bottom of the gridbounddatagrid?

[Administrator]

This is not supported through property settings. You can only freeze rows at the top of the grid through property settings.

Here is a sample that has a class that you can use to add a summary row to either a GridDataBoundgrid or a GridControl. It adds the row at the bottom of the Grid. The idea is to have another grid with a single row and syncronize it with the main Grid.

http://www.syncfusion.com/Support/user/uploads/SummaryRowSample_a06e8668.zip

[Charlie Mao]

Thanks so mcuh for your help. I''ll take a look at the example and get back to you on my status.

[Charlie Mao]

I tried using the sample you sent me, but I just get a gray row on the bottom and it is not summing up the columns or at least I cant see it. Do you know why it is doing this.

gridA.zip

[Administrator]

Hi Charlie,

See the following KB article, and let me know if this satisfies your query.
http://www.syncfusion.com/Support/article.aspx?id=10398

Thanks for using Syncfusion products.

Best Regards,
Haneef.

[Charlie Mao]

Hi,
The above samples worked great, but for some reason, it adds alot of empty rows between the summary row and the original datagrid. You know why its doing this.

CHarlie

[Charlie Mao]

Nevermind, I figured this problem out. Thanks

[Charlie Mao]

Hi, I used the SummaryRows class that you suggested and it worked great. I was wondering, is there a way to adjust this to where you can have multiple summary rows. Like three total rows for example.

[Administrator]

Hi Charlie,

I have created a sample as per your specification. The sample illustrates the possiblity to add the multiple summary rows in a grid. Please refer to the attached sample and let me know if you are trying something different.

Here is a sample.
http://www.syncfusion.com/Support/user/uploads/SummaryRowSample_71a98a86.zip

Best Regards,
Haneef

[Charlie Mao]

Haneef,

That is exactly what I was looking for. Thanks for your help...

Charlie

[Charlie Mao]

The summaryrows work fine, but currently the size is fixed no matter how many rows I have. If I have alot of rows, you have to scroll down. Is there a way to adjust the sitesummaryrow function to always place the summary row at the bottom no matter how many rows there are?

[Administrator]

Hi Charlie,

You can enable the default scrolling in a Summary grid and set ActivateCurrentCellBehavior / SelectCellsMouseButtonsMask property to None. Please refer the attached sample for more details.

//this.summaryGrid.VScrollBehavior = GridScrollbarMode.Disabled;
//this.summaryGrid.HScrollBehavior = GridScrollbarMode.Disabled;
//this.summaryGrid.Enabled = false;

this.summaryGrid.ActivateCurrentCellBehavior = GridCellActivateAction.None;
this.summaryGrid.Model.Options.SelectCellsMouseButtonsMask = MouseButtons.None;

Here is a modified sample.
http://www.syncfusion.com/Support/user/uploads/SummaryRowSample_cd8c9144.zip

Let me know if this helps.
Thanks,
Haneef

[Charlie Mao]

Hey Haneef,

Thanks for replying. I was talking about the location of the summary grid. You can see from the attached file that the summary cuts off some of my rows and for other tables, it places it right. I was wondering if I could set the location to where the summary is always placed at the end of the table no matter how many rows I have. Thanks!!!

summary.zip

[Administrator]

Hi Charlie,

You can change the location of the summary grid in the SiteSummaryRow method. Here is a code snippet.

int vheight = this.grid.Model.RowHeights.GetTotal(this.grid.TopRowIndex,this.grid.Model.RowCount );
this.summaryGrid.Location = new Point(0, vheight + 5);
this.summaryGrid.Size = new Size(this.grid.ClientSize.Width , this.grid.DefaultRowHeight);

private void grid_TopRowChanged(object sender, GridRowColIndexChangedEventArgs e)
{
this.SiteSummaryRow();
}

Please refer the modified sample for more details.
http://www.syncfusion.com/Support/user/uploads/SummaryRowmodified_a42dc2d0.zip

Let me know if you need more information on this.
Thanks,
Haneef