ASP.NET Grid - "Excel-style" editing


 
ORDER ID
 
NAME
 
CITY
 
POSTAL CODE
 
REGION
 
COUNTRY
 
Vins et alcools Chevalier
Vins et alcools Chevalier
Reims
Reims
51100
51100
FR
FR
Brazil
Brazil
Toms Spezialitäten
Toms Spezialitäten
Münster
Münster
44087
44087
Germany
Germany
Hanari Carnes
Hanari Carnes
Rio de Janeiro
Rio de Janeiro
05454-876
05454-876
RJ
RJ
Austria
Austria
Victuailles en stock
Victuailles en stock
Lyon
Lyon
69004
69004
qq
qq
France
France
Suprêmes délices
Suprêmes délices
Charleroi
Charleroi
B-6000
B-6000
Belgium
Belgium
Hanari Carnes
Hanari Carnes
Rio de Janeiro
Rio de Janeiro
05454-876
05454-876
RJ
RJ
Brazil
Brazil
Chop-suey Chinese
Chop-suey Chinese
Bern
Bern
3012
3012
Switzerland
Switzerland
Richter Supermarkt
Richter Supermarkt
Genève
Genève
1204
1204
Switzerland
Switzerland
Wellington Importadora
Wellington Importadora
Resende
Resende
08737-363
08737-363
SP
SP
Brazil
Brazil
HILARION-Abastos
HILARION-Abastos
San Cristóbal
San Cristóbal
5022
5022
Táchira
Táchira
Venezuela
Venezuela
Ernst Handel
Ernst Handel
Graz
Graz
8010
8010
Austria
Austria
Centro comercial Moctezuma
Centro comercial Moctezuma
México D.F.
México D.F.
05022
05022
Mexico
Mexico
Ottilies Käseladen
Ottilies Käseladen
Köln
Köln
50739
50739
Germany
Germany
Que Delícia
Que Delícia
Rio de Janeiro
Rio de Janeiro
02389-673
02389-673
RJ
RJ
Brazil
Brazil
Rattlesnake Canyon Grocery
Rattlesnake Canyon Grocery
Albuquerque
Albuquerque
87110
87110
NM
NM
USA
USA


You can edit the cells from the grid like in MS Excel.
Use the arrow keys to navigate through cells.

"Your tools are fantastic."

Aaron Gillam
Haynes International, Inc.

Products Downloads
obout.com
obout.com Home
News New
Grid Home 
Grid Home
Download
Site Map
Examples - 197
Appearance - 2
Live Styles
Populating with data - 11
Binding to DataSet
Binding to DataReader
Binding to DataTable
Binding to ObjectDataSource
Binding to SqlDataSource
Binding to XmlDataSource
Binding to Linq
Binding to LinqDataSource
Binding to Generic Collections
Maximum Performance
Partial Load
Add/Edit/Delete - 14
Add/Edit/Delete Records
Type Validation
Edit on Double-Click
Add/Edit Default Values
Auto-Save & Dbl-Click
Edit using Context-Menu
Multi-Record
Use Add/Edit Forms
Automatic Updates
Using Flyout
Add to empty table
Edit all Cells
Declarative (no coding)
Excel-Style Editing
Using ObjectDataSource New
Select Records - 10
Select Records
Keep Selected Records
Find Selected on Client-Side
Find Selected on Server-Side
Select/Deselect Record
Set the SelectedRecords
Using Checkboxes
AutoPostBackOnSelect
Using Radio-Buttons
With Checkmark New
Columns - 18
Resizing Columns
Align / HeaderAlign
AllowEdit / AllowDelete
DataFormatString
ApplyFormatInEditMode
Index
NullDisplayText
ParseHTML
ReadOnly
Show/Hide Columns
Visible
Width
Wrap
AutoGenerateColumns
Relative Widths
Resize the Grid Width
Different Styles New
Column sets New
Paging- 6
Paging
Customize Paging
Change Page on Client
The Numbers of Pages
Manual Paging
Show ALL records
Sorting - 2
Sorting
Multi-Column Sorting
Filtering - 9
Filtering Records
Enable/Disable Filter
Show/Hide Criterias
Autosuggest Filtering
Customize Filtering Options
Programmatic Filter - Client-Side
Initial Filter
Alphabetic Filter
Keeping Filter State New
Templates - 25
Templates for Add/Edit
Templates for the Filter
Format Dates
Format Currencies
Grid With Images
Add/Edit/Delete Buttons
Filter Buttons
Combine Columns
Wrap the Headers
Custom Formatting
Manual Paging
Number the records
GroupHeaderTemplateId
Multi-Record Add/Edit/Del.
Customized Row Templates
Templates for Edit-Delete
Reports and Row Templates
Access checkboxes inside
Access radio buttons inside
With Multiselect Listbox
With Databound Controls
DropDownList with 'New'
View / Edit Details
Customize for Mobile Devices New
Scrolling - 9
Vertical
Horizontal
Vertical & Horizontal
Automatic Scroll
Horizontal & Filter
Automatic Resize
Fixed (Frozen) Columns
Automatic Resize With Window
Fixed Height New
Grouping - 11
Grouping the Records
Allow Grouping for Columns
Initial Grouping
Groups Information
Multi-Page Groups Information
Collapsed Groups
Expand/Collapse Groups
Hide Columns
Keep Expanded
Format the Group Headers New
Customize the Group Headers New
Totals / Sub-Totals - 4
Totals
Groups Sub-Totals
Aggregates
Totals of Selected Records New
Master / Detail - 17
Load At Once (OnLoad)
Load On Demand (OnCallback)
Detail Grid State
Multiple Details on the Same Lev
Self-Reference Display
Unlimited Number of Levels
Show Empty Details
Full Set of Features
Expand/Collapse All
Multiple Foreign Keys New
Templates for Action Buttons New
Client-Side Manipulation New
Get Selected Records New
Expand/Collapse on Select New
Different Styles New
Select on Expand / Collapse New
Expand a single detail grid New
Expand on client side New
Exporting - 6
To Excel and Word
Customize Exported files
Exported files Life Time
Server-Side Exporting
OnClientExportStart/Finish
ExportedFilesTargetWindow
Accessibility - 2
Key Navigation
Customize the Keys
Localization - 2
Localization
Custom Localization
Client-Side Events - 2
Add / Edit / Delete
Expose the Sender New
Server-Side Events - 3
RowCreated/RowDataBound
ColumnsCreated
Row Title
Printing - 1
Printing the Grid
Integration - 24
E-Mail Client
File Browser
D-n-D to Tree
D-n-D to Grid
Customers
With EasyMenu
With DatePicker
With FileUpload
With Flyout
With SuperButton
AJAX Autosuggest
Linked with TreeView
Using Validation Controls
With Window
Purchase Order
Task List
Using Tooltips
With Multilevel Combobox
With AJAX TabStrip
With HTML Editor
Inside Window
Context menu and CheckBoxes
With ColorPicker
With FileUploadProgress New
ASP.NET AJAX - 3
Live Quotes
With AJAX MaskedEditExtender
With AJAX AlwaysVisible New
Other Features - 14
ShowLoadingMessage
Hover Effects
Millions of Records
Multiple Grids
Refresh the Records
Generate IDs
Client-Side Model
Get Values on Server-Side
Clear the records
Re-order the rows
Handling errors
Master/Detail
Find and Replace
Mode - 2
Callback Mode
Postback Mode
Knowledge Base - 2
How-To and Help
Knowledge Base
Documentation - 24
Server-Side
Column
ColumnCollection
ColumnTemplateSettings
DetailGridLoadingMode
DetailGridState
FilterOption
FilterOptionsCollection
FilterOptionType
Grid
GridClientSideEvents
GridCssSettings
GridGroupInformation
GridLocalizationSettings
GridMasterDetailSettings
GridRecordEventArgs
GridRuntimeTemplate
GridRuntimeTemplateEventArgs
GridScrollingSettings
GridTemplate
GridTemplateSettings
SortOrderType
TemplateContainer
TemplatesCollection
Client-Side
Client-Side API
Changelog
Tutorials - 18
Add/Edit/Delete
Updating the Database
Updating using Linq
Appearance
Styles
Styles - Advanced
CSS Tutorial
Client-Side API
Client-Side Events
Columns
Columns
Configuration
Using the correct path
Design-Time Support
All Tutorials
Choosing Data Source
Changing Appearance
Populating with Data
Data-Binding
Serialize
Maximum Performance
Selecting Records
Access Selected Records
Templates
Templates
Runtime Templates
Templates for Buttons
Miscellaneous Tutorials - 24
Getting the Generated ID
Multi columns validation
Loading the details with AjaxPages
Selecting the inserted/updated record
Server-side validation using Ajax
Edit on Click
Hide "no-records" message
Using radios inside edit template
Keep Current Page
Keep Current Paging/Sorting
External buttons
Sending parameters
Disable combobox in Edit mode
Bind data after specified the filter
Get Column Index in template
Client-Side Events & Window
Export with loading message
Custom readonly column
Validate unknown columns
Auto-scroll during postback
Delete button
Inline validation
Move records between grids New