Questions about datagrid

Aspose.Cells Product Family
1

I am with the Dept. of the Navy, and we would like to evaluate your datagrid control. Please let me know if the control can do the following…

User select number of rows to display per page (Show 10, Show 20, etc.)

Pagination: Previous/Next and First/Last Buttons, Display page X of X

Grouping of data

AJAX Enabled behaviors

Save User profile (preferences, columns displayed, etc.)

Conditional Formatting

Preset Display Styles (Office 07, etc.)

Summary Row

This message was posted using Email2Forum by Merit.
2

Hi,

Thanks for considering Aspose.

I think Aspose.Grid can serve your need. I will also try to answer you queries by referencing some of our featured demos:

The featured demos are automatically installed on your system when you use Aspose.Grid.msi installer to install it. So, you may open the demos solutions in your VS.NET and check the source codes.

User select number of rows to display per page (Show 10, Show 20, etc.)

Do you mean records per page for paging. You can set it for your need: e.g.,

// Allows Paging.
GridWeb1.EnablePaging = true;
// Specifies the Size 20 rows per Page.
GridWeb1.PageSize = 20;

You can also set the grid's matrix: e.g..,

private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{

GridWeb1.MaxColumn = 85;
GridWeb1.MaxRow = 10;
}
}

Pagination: Previous/Next and First/Last Buttons, Display page X of X

Please check: Pagination demo

Grouping of data

Please check: Grouping demo and Subtotal demo

AJAX Enabled behaviors

Please check: Subtotal demo

Save User profile (preferences, columns displayed, etc.)

I think you can set session modes, please check: Aspose.Total Product Family

Another example is here: e.g.,

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using Aspose.Grid.Web;
using Aspose.Grid.Web.Data;

namespace Aspose.Grid.Web.DemosCS
{
///


/// Summary description for WebForm8.
///

public class WebForm8 : System.Web.UI.Page
{
protected Aspose.Grid.Web.GridWeb GridWeb1;

private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{

GridWeb1.WebWorksheets.Clear();
//GridWeb1.EnableSession = false;
GridWeb1.SessionMode = SessionMode.Custom;
// Loads the initial data, from file or database.
GridWeb1.WebWorksheets.ImportExcelFile("d:/test/test.xls");
// Do something.....................
// Saves the session data.
GridWeb1.SaveAGW2File("d:/test/save.agw2");
}
}
private void GridWeb1_SheetDataUpdated(object sender, System.EventArgs e)
{
// Handles the SheetDataUpdated event.
// Saves the session data for each update.
GridWeb1.SaveAGW2File("d:/test/save.agw2");
}

private void GridWeb1_LoadCustomData(object sender, System.EventArgs e)
{
// Handles the LoadCustomData event.
// Loads the session data.
GridWeb1.LoadAGW2File("d:/test/save.agw2");
}

Conditional Formatting

It’s not supported yet.

Preset Display Styles (Office 07, etc.)

Please check: ChangeStyle demo

Summary Row

Please check: Grouping demo and Subtotal demo

And kindly check Aspose.Grid documentation: Aspose.Total Product Family for your further reference.

Thank you.