I found the following control that provides similar features I am looking for, but still too far from my requirements:

http://demo.essentialobjects.com/Default.aspx?path=Grid

I am now starting the program changes to convert a GridView to make work like Excel Sheet, or as close as possible. This is really urgent, and I need your help.

As a matter of fact, I found many possible solutions, and I am facing issues taking one solution, either becuase the solution is too complex to implement or it does not meet the requirements.

I will mention the requirements:

1. Allow the user to update the GridView Content using the Keyboard Only. No need to use the mous.

2. The user must be able to update on the same page (in-line editing).

3. Use the arrow keys [up], [down], [left] and [right] to locate the required row/cell to be edited.

4. Use the [enter] key to start editing. When [enter] is pressed, all the fields in the same row must become editable fields. Press [enter] again to switch to display mode.

5. Use [esc] to cancel the edits made to the current cell. Use [esc] again to cancel the update made to the complete row.

5. When in editing mode, use [tab] and [sihft-tab] to goto next/prev field in the same row.

6. All updates to be cashed on the client.

7. User can click on "Save" to update the changes on the server.

8. User can click on "Cancel" to cancel all updates made on the client.

9. The GridView or the Control providing the control features mentioned above, must connect bindable to a .NET Based Data Source like SqlDataSource or ObjectDataSource.

I found one Coolite Control:

http://examples.coolite.com/?/GridPanel/DataSource_Update/SqlDataSource/

which is providing as close as possible to my reuqirements. But I am worried about the readiness of Coolite Controls.

I don't want to be too greedy, and if I can find a solution that can give me 70% of the above reuqirements, I will be very happy.

I really appreciate your help on this.

Tarek.

Thank you sooo much for coming back to me so quickly.

I will go thorugh the guid you provied.

In the mean time, please tell me if this essentialobjects framework is free and what is the minimum requirements to get started with minimum cost and effort.

Tarek.

Hi,

Our Grid is not free. The cost is $169/Developer.

The keyboard support for your requirement is easy. All you need to do is to set EnableKeybaordNaviagion to true. See here for a working example:

http://demo.essentialobjects.com/Default.aspx?path=Grid\_i1\_i21

However in order to use our Grid in any way, you will need to first understand how our Grid works in general. You can go over other samples in the sample project to get a basic idea of how it works. You have the full source code of the sample project on your local machine at Start -> All Programs -> EO.Web Controls 7.0 (2009) -> EO.Web Controls for ASP.NET xx -> Live Demo. You can copy the sample source code into your test project to try them out.

Several most important things about our Grid are:

1. How to define Grid columns;
2. How to style the Grid;
3. How to edit Grid;

There are no easy simple shortcut that we can just "point you" towards for those. The document we provided to you is exactly where you need to start with to get familiar with these questions. We could explain all those to you again at here, but that will be basically copy and paste from the document. It will be better if you go over the document first, then ask us if you have any specific questions.

Thanks!

Hi,

Glad that we were able to help. The cost includes unlimited servers/web application. I believe the trial works for 30 days.

Thanks!

Hi,

Thanks for sharing. That probably has to do the settings on your laptop. Line 121 is the Google Analytics Javascript code. It's unlikely Google Analytics would have such a bug on IE 8 because its being used by millions of users. However if you have blocked Google Analytics's server on your machine (www.google-analytics.com), then you will get this error.

The off-line copy of the documentation is already on your machine. You can find it from Start -> All Programs -> EO.Web Controls 7.0 (2009) -> EO.Web Controls for ASP.NET xxx -> Documentation.

Thanks!

Of course. We support all major VS versions: VS 2003, VS 2005, VS 2008 and VS2010.

Thanks

That explains. You should remove it.

Thanks

Hi,

Thanks for letting us know. It is most likely that there is something else wrong on your computer, just like the Google Analytics entry because nobody else has reported such issues. We do not see any issues either. So I would recommend you just use the off-line version. The off-line version is not only faster, but also usually newer than the online version. The online version is mainly for us to point user to the right direction because we can post a direct link to any help page.

Thanks!

Hi,

As to your questions:

1. Check your ColumnHeaderHeight and the column header's background in ColumnHeaderStyle property. If you do not have a background color or background image, you see your row data overlap with the header. If you do have a background image, but the height of the image is less than ColumnHeaderHeight, then you will see your row data overlaop with the header too.

2. Great. Glad to see that works;

3. You can set the GridColumn's Width to -1 to set it as "auto fill". Note you can only have one Column to have auto-fill;

Hope this helps.

Thanks!

Great. Glad that you worked that out!

Thanks!