This is a migrated thread and some comments may be shown as answers.

How I can achieve Excel-like data entry form

1 Answer 137 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Tariq
Top achievements
Rank 1
Tariq asked on 10 Jul 2008, 01:22 PM
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

1 Answer, 1 is accepted

Sort by
0
Vlad
Telerik team
answered on 10 Jul 2008, 02:01 PM
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
Top achievements
Rank 2
Iron
Veteran
Iron
commented on 01 Feb 2022, 05:50 PM

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

Frowny face

Doncho
Telerik team
commented on 02 Feb 2022, 12:03 PM

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

Tags
Grid
Asked by
Tariq
Top achievements
Rank 1
Answers by
Vlad
Telerik team
Share this question
or