Need grid for asp.net application

Aspose.Cells Product Family
1

Hi,

We are planing to develop a web application using asp.net and want to use a grid for data entry purpose.
The basic requirement about grid is as follows
1) We should able to bind data from database to grid.
2) We should be able to edit the cells.
3) We should be able to add and delete new rows to the grid from client side and newly added/deleted rows should be available at server side code.
4) We should be able to add javascript validation on grid cells.
5) We should be able to add different control to the grid cell.

For e.g. In our grid there are 3 columns1st column will contain datetime picker to select2nd column will contain 1 combobox having some options in it to select.3rd column will not contain any control but we should be able to edit the cell.

So when user will save the button we should get the datetime picker selected value, combox selected value and 3rd column cell value at server side code to save it in database on row by row basis.

So can anyone please advise that the aspose.cells component will fulfill our all above requirements?


Thanks and Regards
Prasad

2

Hi Prasad,

Thanks for your posting and considering Aspose.Cells.

Aspose.Cells provides a grid component namely Aspose.Cells.GridWeb which fulfills your requirements. Once you will get familiar with it, you will be able to meet your requirements. Initially for the demonstration, please check the sample gridweb project
that shows how to import xls file. I have also attached the screenshot
showing how it looks when the sample runs successfully. Please download
it and run at your end to see it in action.

Please also read about Aspose.Cells.GridWeb documentation and see its examples (try to check all of the examples) from the following links so that you could get familiar with it quickly and meet up your requirements.

( http://www.aspose.com/docs/display/cellsnet/Aspose.Cells.GridWeb )
( Aspose.Cells.GridWeb Demos )

3

Hi Shakeel,

Thanks for giving information and reply.
We are looking into this.

Can you please advise what are hardware and software system requirement specification for this grid?
For e.g. Operating System, .NET frame work required etc.

Also we want to know that does this grid works with asp.net ajax based application?

Thanks and Regards
Prasad.G.Godbole

4

Hi,


Please see the System Requirements page for your reference:
http://www.aspose.com/docs/display/cellsnet/System+Requirements

(Note: please see the contents under the heading “Aspose.Cells Grid Suite System Requirements” in the document for your reference).

Also, Aspose.Cells.GridWeb control does support ASP.NET Ajax applications.

Thank you.

5

Hi,

Thanks for giving information.
Regarding system requirement. It is mentioned that it will support up to Microsoft Windows Server 2008 OS. So will it not work for later versions of Windows Server OS i.e Microsoft Windows Server 2012 and onwards etc.

For how much bit of Operating System and machine this Aspose.Cells Grid Suite is supported?

Also in previous response it was mentioned that we can add new rows/delete rows in the GridWeb from client side but in below link of your site it is mentioned that we can’t add new rows/ delete rows from client side via javascript.

Adding a row to webgrid w/o postback via javascript in .NET

Can you please once again confirm that we can add new rows/delete rows from client side via javascript?

Thanks and Regards
Prasad

6

Hi Prasad,

Thanks for your posting and using Aspose.Cells.

GridWeb only depends on ASP.NET-Net Framework 2.0. It does not have any dependency on OS. Wherever ASP.NET 2.0 or greater is installed, GridWeb will be able to run.

It should be possible to add new rows or deleting existing rows from client side script or AJAX but for add/delete operation some sort of server code will also be necessary.

We have logged this issue in our database for investigation. We will let you know that if your requirement can be meet purely from client side script or some server side script will also be essential to play this role. Once there is some update will be available for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43853 - Add new rows or delete existing rows in GridWeb from client side via javascript

7

Hi Shakeel,

Thanks for giving information. We will wait for your reply.

Thanks and Regards
Prasad

8

Hi Prasad,

Thanks for your posting and considering Aspose.Cells.GridWeb.

Sure, we will keep you in a loop.

9

Hi,


Please follow this approach:
Suppose the GridWeb id is “gridwebID”, so you will use the following client side code to remove a row at specified location in GridWeb matrix.
e.g
Sample code:

…

//first get gridweb instance
var instance=$("#gridwebID")[0];
//select cell by zero based index row column ,here we select cell on row 5,column 2
var cell=instance.getCell(4, 1);
//select cell
instance.selectCell(cell);
//call delete action
instance.postBack(“DELETEROW”, false);
…

Please feel free to copy the “acwmain.js” in the “\acw_client” folder at your installation directory and then open the resource file to explore it to find different client side commands on adding rows, deleting rows etc. by yourself for your reference. This is an open source resource file.

Thank you.
10

Hi,

Thanks for giving information.

We have created a power point demo for our requirements.

Please download the following rar file from below URL.

http://s114699993.websitehome.co.uk/NRJ/NRJ/GridPowerPointDemo.rar

Please extract this rar file. After extratcing rar file, you will get a “GridDemo.ppt” file (powe point file) in “PowerPoint” folder.

Now please run the slide show of “GridDemo.ppt” file. In this demo we have a grid for desktop application and like this grid we want to achieve functionality in aspose gridweb.

There are 3 slides having name Slide 1, Slide 2 and Slide 3. Each slide contains the description about grid functioning.

Though you have mentioned that the aspose gridweb can fulfill our requirement but can you please cross check again by watching this demo ppt and confirm that such type of functionality we can achieve in aspose gridweb.


Thanks and Regards
Prasad

11

Hi Prasad,

Thanks for considering Aspose.Cells for GridWeb.

Calendar control is not available in GridWeb. However, if you need it then we will add a feature request for it. Other things are possible e.g

1 - Formatted Date - you will add 05/04/2014 and it will automatically be formatted to April 05 2014.
2 - Dropdown List with Data
3 - Insert New Row

I have attached the sample gridweb project, please download it and try it at your end. I have also attached the screenshots in a word document that shows how it looks when it is running.

I achieved these things in a source.xlsx file which I created manually using Microsoft Excel, the code just loads the source excel file and achieve your requirements. You can create all these things programmatically too, but using the existing template file is the easiest and quick approach.

12

Hi Shakeel,

Thanks for sending sample project. We are looking into it.
Just saw the doc file containing screen shots. In that to add new row we are using insert row option. Can’t we add the new row automatically (using javascript) like our ppt demo i.e. without using insert row option?

Please advise us.

Thanks and Regards
Prasad

13

Hi Prasad,

Thanks for your posting and considering Aspose.Cells.GridWeb.

We have logged your requirement in our database for investigation and analysis. We will look into it and see if we could implement it. Once, there is some fix or other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43924 - Insert new row automatically when user ends filling the current row

14

Hi Shakeel,

Thanks. If required please refer my all old conversation with Amjad. May be it will be useful to analyze this.

Thanks and Regards
Prasad

15

Hi Prasad,

Thanks for your posting and considering Aspose.Cells for GridWeb.

We will surely refer to your old conversion if necessary. Please spare us some time. Once there is some news for you, we will share it with you asap.

16

Hi Shakeel,

Yes sure. No problem.

Thanks and Regards
Prasad

17

Hi,


We have evaluated your issue logged earlier as “CELLSNET-43924”. Well, since it is not a common feature, so we won’t support it. We think you can do it by yourself, you just need to call postBack(“ADDROW”); on client side.

Thank you.