We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Questions about datagrid

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.

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: http://www.aspose.com/demos/aspose.grid/default.htm 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: http://www.aspose.com/demos/aspose.grid/description/common/pagination.htm

Grouping of data

Please check: http://www.aspose.com/demos/aspose.grid/description/grouping/grouping.htm

http://www.aspose.com/demos/aspose.grid/description/grouping/subtotal.htm


AJAX Enabled behaviors

Please check: http://www.aspose.com/demos/aspose.grid/description/grouping/subtotal.htm


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

I think you can set session modes, please check: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/introduction-to-different-grid-modes.html: . 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: http://www.aspose.com/demos/aspose.grid/description/common/changestyle.htm

Summary Row

Please check: http://www.aspose.com/demos/aspose.grid/description/grouping/grouping.htm

http://www.aspose.com/demos/aspose.grid/description/grouping/subtotal.htm

And kindly check Aspose.Grid documentation: http://www.aspose.com/documentation/visual-components/aspose.grid-for-.net/index.html for your further reference.

Thank you.