How I can achieve Excel-like data entry form

[Tariq]

In one of my "Timesheet" application, the user has to enter around 300 rows in a single session.  I want to give him an Excel-like data entry form where he can do bulk data entry.  I tried to use the RadGrid for this purpose, but user has to click at the "Insert and Add" buttons at every row that he enters.  

Is there a way to use RadGrid where the user keeps on entering records and in the end executes a single Batch Insert. I don't mind if the user has to insert, for example, 100 blank records and then fill them one by one. 

What I want to achieve is that there is no button-click and no post-back until he explicitly does so.

Any suggestion.

 Tariq

[Vlad]

Hi Tariq,

You can try this example:
http://www.telerik.com/community/code-library/submission/b311D-babbkh.aspx

Best wishes,
Vlad
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[SMc]

UGH!!! This looked like it might be the solution I'm looking for, but the link is broken!!! 

Frowny face

[Doncho]

Hi Sean,

I have just sent an answer to your question in the formal support ticket you have opened on the same topic.

I will suggest proceeding with the communication there only.

For better visibility I am pasting the relevant part of my answer here as well:

One approach I can suggest you is to use the BatchEditing mode of the RadGrid and apply some custom JavaScript code to achieve the current requirements, see our live demo Batch Editing.

In short, you can make avail of the OnKeyPress client-side event handler to determine the exact case and use the addNewRecord method to achieve the requirement, see http://www.telerik.com/help/aspnet-ajax/grid-batch-editing.html.

As to the linked example in this forum, it shows an approach for customizing the RadGrid in a version before the BatchEditing functionality has been released. You can find the code library sample here - https://www.telerik.com/support/code-library/excel-look-and-feel-for-radgrid