Batch editing

GridControl

Double-click a cell, type, press Enter: cell-by-cell editing on a 5,000-row list, written straight to the bound objects.

Overview

EditSettings turns editing on and picks the mode. In EditMode.Batch a double-click on an editable cell, or Enter on the selected cell, opens an editor in that cell; Tab or Enter commits the value to the bound object and Escape abandons it. There is no row editor and no save button. Columns opt in with AllowEditing. GridControlEvents reports what happens: OnCellEdit before a cell opens (set Cancel to refuse) and OnCellSave when a value is written.

Examples

#Edit cells in place

Five thousand generated rows held in memory. Item Code, Phase and Phase Title are read-only; double-click any other cell, or select it and press Enter, to edit it. Enter commits and stays on the cell, Tab commits and moves the selection to the next editable cell, Escape abandons the edit. The line under the grid counts saves and names the last one.

Example
Razor
C#
Item Code Description Phase Phase Title Cost Category UOM Unit Price Waste % PO Index
ITM-00001Foundation & Concrete Specification 10200Foundation & ConcreteMaterialLF$582.895PO-002
ITM-00002Framing & Timber Specification 20300Framing & TimberLaborSF$134.775PO-003
ITM-00003Roofing & Siding Specification 30400Roofing & SidingSubcontractCY$121.695PO-004
ITM-00004Plumbing Rough-In Specification 40500Plumbing Rough-InMaterialHRS$459.355PO-005
ITM-00005Electrical & Lighting Specification 50600Electrical & LightingLaborBOX$158.1710PO-006
ITM-00006HVAC & Insulation Specification 60700HVAC & InsulationSubcontractEA$238.205PO-007
ITM-00007Drywall & Texturing Specification 70800Drywall & TexturingMaterialLF$630.755PO-008
ITM-00008Interior Trim & Doors Specification 80900Interior Trim & DoorsLaborSF$450.985PO-009
ITM-00009Flooring & Tile Specification 91000Flooring & TileSubcontractCY$162.605PO-010
ITM-00010Paint & Finish Specification 101100Paint & FinishMaterialHRS$662.0610PO-011
ITM-00011Cabinets & Countertops Specification 111200Cabinets & CountertopsLaborBOX$214.405PO-012
ITM-00012Sitework & Excavation Specification 120100Sitework & ExcavationSubcontractEA$233.725PO-013
ITM-00013Foundation & Concrete Specification 130200Foundation & ConcreteMaterialLF$444.765PO-014
ITM-00014Framing & Timber Specification 140300Framing & TimberLaborSF$287.205PO-015
ITM-00015Roofing & Siding Specification 150400Roofing & SidingSubcontractCY$338.8210PO-016
ITM-00016Plumbing Rough-In Specification 160500Plumbing Rough-InMaterialHRS$236.215PO-017
ITM-00017Electrical & Lighting Specification 170600Electrical & LightingLaborBOX$454.835PO-018
ITM-00018HVAC & Insulation Specification 180700HVAC & InsulationSubcontractEA$45.025PO-019
ITM-00019Drywall & Texturing Specification 190800Drywall & TexturingMaterialLF$707.025PO-020
ITM-00020Interior Trim & Doors Specification 200900Interior Trim & DoorsLaborSF$505.6210PO-021
ITM-00021Flooring & Tile Specification 211000Flooring & TileSubcontractCY$352.855PO-022
ITM-00022Paint & Finish Specification 221100Paint & FinishMaterialHRS$144.365PO-023
ITM-00023Cabinets & Countertops Specification 231200Cabinets & CountertopsLaborBOX$91.605PO-024
ITM-00024Sitework & Excavation Specification 240100Sitework & ExcavationSubcontractEA$614.385PO-025
ITM-00025Foundation & Concrete Specification 250200Foundation & ConcreteMaterialLF$708.7510PO-026
ITM-00026Framing & Timber Specification 260300Framing & TimberLaborSF$473.975PO-027
ITM-00027Roofing & Siding Specification 270400Roofing & SidingSubcontractCY$52.535PO-028
ITM-00028Plumbing Rough-In Specification 280500Plumbing Rough-InMaterialHRS$619.485PO-029
ITM-00029Electrical & Lighting Specification 290600Electrical & LightingLaborBOX$140.605PO-030
ITM-00030HVAC & Insulation Specification 300700HVAC & InsulationSubcontractEA$785.2810PO-031
ITM-00031Drywall & Texturing Specification 310800Drywall & TexturingMaterialLF$603.705PO-032
ITM-00032Interior Trim & Doors Specification 320900Interior Trim & DoorsLaborSF$453.955PO-033
ITM-00033Flooring & Tile Specification 331000Flooring & TileSubcontractCY$173.425PO-034
ITM-00034Paint & Finish Specification 341100Paint & FinishMaterialHRS$50.285PO-035
ITM-00035Cabinets & Countertops Specification 351200Cabinets & CountertopsLaborBOX$276.9710PO-036
ITM-00036Sitework & Excavation Specification 360100Sitework & ExcavationSubcontractEA$510.695PO-037
ITM-00037Foundation & Concrete Specification 370200Foundation & ConcreteMaterialLF$712.915PO-038
ITM-00038Framing & Timber Specification 380300Framing & TimberLaborSF$18.365PO-039
ITM-00039Roofing & Siding Specification 390400Roofing & SidingSubcontractCY$470.365PO-040
ITM-00040Plumbing Rough-In Specification 400500Plumbing Rough-InMaterialHRS$699.4110PO-001
ITM-00041Electrical & Lighting Specification 410600Electrical & LightingLaborBOX$651.115PO-002
ITM-00042HVAC & Insulation Specification 420700HVAC & InsulationSubcontractEA$341.895PO-003
ITM-00043Drywall & Texturing Specification 430800Drywall & TexturingMaterialLF$141.755PO-004
ITM-00044Interior Trim & Doors Specification 440900Interior Trim & DoorsLaborSF$37.395PO-005
ITM-00045Flooring & Tile Specification 451000Flooring & TileSubcontractCY$58.3610PO-006
ITM-00046Paint & Finish Specification 461100Paint & FinishMaterialHRS$679.405PO-007
ITM-00047Cabinets & Countertops Specification 471200Cabinets & CountertopsLaborBOX$547.495PO-008
ITM-00048Sitework & Excavation Specification 480100Sitework & ExcavationSubcontractEA$112.905PO-009
ITM-00049Foundation & Concrete Specification 490200Foundation & ConcreteMaterialLF$227.475PO-010
ITM-00050Framing & Timber Specification 500300Framing & TimberLaborSF$671.5610PO-011
ITM-00051Roofing & Siding Specification 510400Roofing & SidingSubcontractCY$261.175PO-012
ITM-00052Plumbing Rough-In Specification 520500Plumbing Rough-InMaterialHRS$565.925PO-013
ITM-00053Electrical & Lighting Specification 530600Electrical & LightingLaborBOX$137.105PO-014
ITM-00054HVAC & Insulation Specification 540700HVAC & InsulationSubcontractEA$52.825PO-015
ITM-00055Drywall & Texturing Specification 550800Drywall & TexturingMaterialLF$528.8810PO-016
ITM-00056Interior Trim & Doors Specification 560900Interior Trim & DoorsLaborSF$453.535PO-017
ITM-00057Flooring & Tile Specification 571000Flooring & TileSubcontractCY$58.185PO-018
ITM-00058Paint & Finish Specification 581100Paint & FinishMaterialHRS$372.315PO-019
ITM-00059Cabinets & Countertops Specification 591200Cabinets & CountertopsLaborBOX$615.595PO-020
ITM-00060Sitework & Excavation Specification 600100Sitework & ExcavationSubcontractEA$549.1910PO-021
ITM-00061Foundation & Concrete Specification 610200Foundation & ConcreteMaterialLF$200.685PO-022
ITM-00062Framing & Timber Specification 620300Framing & TimberLaborSF$26.275PO-023
ITM-00063Roofing & Siding Specification 630400Roofing & SidingSubcontractCY$325.395PO-024
ITM-00064Plumbing Rough-In Specification 640500Plumbing Rough-InMaterialHRS$242.325PO-025
ITM-00065Electrical & Lighting Specification 650600Electrical & LightingLaborBOX$73.3610PO-026
ITM-00066HVAC & Insulation Specification 660700HVAC & InsulationSubcontractEA$625.455PO-027
ITM-00067Drywall & Texturing Specification 670800Drywall & TexturingMaterialLF$75.305PO-028
ITM-00068Interior Trim & Doors Specification 680900Interior Trim & DoorsLaborSF$409.485PO-029
ITM-00069Flooring & Tile Specification 691000Flooring & TileSubcontractCY$25.235PO-030
ITM-00070Paint & Finish Specification 701100Paint & FinishMaterialHRS$693.1410PO-031
ITM-00071Cabinets & Countertops Specification 711200Cabinets & CountertopsLaborBOX$388.305PO-032
ITM-00072Sitework & Excavation Specification 720100Sitework & ExcavationSubcontractEA$451.475PO-033
ITM-00073Foundation & Concrete Specification 730200Foundation & ConcreteMaterialLF$439.665PO-034
ITM-00074Framing & Timber Specification 740300Framing & TimberLaborSF$22.615PO-035
ITM-00075Roofing & Siding Specification 750400Roofing & SidingSubcontractCY$719.5110PO-036
ITM-00076Plumbing Rough-In Specification 760500Plumbing Rough-InMaterialHRS$25.965PO-037
ITM-00077Electrical & Lighting Specification 770600Electrical & LightingLaborBOX$17.615PO-038
ITM-00078HVAC & Insulation Specification 780700HVAC & InsulationSubcontractEA$69.215PO-039
ITM-00079Drywall & Texturing Specification 790800Drywall & TexturingMaterialLF$571.025PO-040
ITM-00080Interior Trim & Doors Specification 800900Interior Trim & DoorsLaborSF$44.3610PO-001
ITM-00081Flooring & Tile Specification 811000Flooring & TileSubcontractCY$791.495PO-002
ITM-00082Paint & Finish Specification 821100Paint & FinishMaterialHRS$804.635PO-003
ITM-00083Cabinets & Countertops Specification 831200Cabinets & CountertopsLaborBOX$407.015PO-004
ITM-00084Sitework & Excavation Specification 840100Sitework & ExcavationSubcontractEA$334.035PO-005
ITM-00085Foundation & Concrete Specification 850200Foundation & ConcreteMaterialLF$539.1210PO-006
ITM-00086Framing & Timber Specification 860300Framing & TimberLaborSF$52.785PO-007
ITM-00087Roofing & Siding Specification 870400Roofing & SidingSubcontractCY$331.855PO-008
ITM-00088Plumbing Rough-In Specification 880500Plumbing Rough-InMaterialHRS$135.605PO-009
ITM-00089Electrical & Lighting Specification 890600Electrical & LightingLaborBOX$386.415PO-010
ITM-00090HVAC & Insulation Specification 900700HVAC & InsulationSubcontractEA$688.4410PO-011
ITM-00091Drywall & Texturing Specification 910800Drywall & TexturingMaterialLF$467.515PO-012
ITM-00092Interior Trim & Doors Specification 920900Interior Trim & DoorsLaborSF$355.595PO-013
ITM-00093Flooring & Tile Specification 931000Flooring & TileSubcontractCY$267.775PO-014
ITM-00094Paint & Finish Specification 941100Paint & FinishMaterialHRS$786.175PO-015
ITM-00095Cabinets & Countertops Specification 951200Cabinets & CountertopsLaborBOX$513.7310PO-016
ITM-00096Sitework & Excavation Specification 960100Sitework & ExcavationSubcontractEA$639.845PO-017
ITM-00097Foundation & Concrete Specification 970200Foundation & ConcreteMaterialLF$31.505PO-018
ITM-00098Framing & Timber Specification 980300Framing & TimberLaborSF$764.435PO-019
ITM-00099Roofing & Siding Specification 990400Roofing & SidingSubcontractCY$829.035PO-020
ITM-00100Plumbing Rough-In Specification 1000500Plumbing Rough-InMaterialHRS$297.9110PO-021
ITM-00101Electrical & Lighting Specification 1010600Electrical & LightingLaborBOX$619.095PO-022
ITM-00102HVAC & Insulation Specification 1020700HVAC & InsulationSubcontractEA$153.015PO-023
ITM-00103Drywall & Texturing Specification 1030800Drywall & TexturingMaterialLF$102.675PO-024
ITM-00104Interior Trim & Doors Specification 1040900Interior Trim & DoorsLaborSF$399.335PO-025
ITM-00105Flooring & Tile Specification 1051000Flooring & TileSubcontractCY$298.2610PO-026
ITM-00106Paint & Finish Specification 1061100Paint & FinishMaterialHRS$674.695PO-027
ITM-00107Cabinets & Countertops Specification 1071200Cabinets & CountertopsLaborBOX$141.275PO-028
ITM-00108Sitework & Excavation Specification 1080100Sitework & ExcavationSubcontractEA$129.495PO-029
ITM-00109Foundation & Concrete Specification 1090200Foundation & ConcreteMaterialLF$198.315PO-030
ITM-00110Framing & Timber Specification 1100300Framing & TimberLaborSF$517.9110PO-031
ITM-00111Roofing & Siding Specification 1110400Roofing & SidingSubcontractCY$450.915PO-032
ITM-00112Plumbing Rough-In Specification 1120500Plumbing Rough-InMaterialHRS$853.975PO-033
ITM-00113Electrical & Lighting Specification 1130600Electrical & LightingLaborBOX$666.295PO-034
ITM-00114HVAC & Insulation Specification 1140700HVAC & InsulationSubcontractEA$586.245PO-035
ITM-00115Drywall & Texturing Specification 1150800Drywall & TexturingMaterialLF$622.7110PO-036
ITM-00116Interior Trim & Doors Specification 1160900Interior Trim & DoorsLaborSF$261.055PO-037
ITM-00117Flooring & Tile Specification 1171000Flooring & TileSubcontractCY$484.255PO-038
ITM-00118Paint & Finish Specification 1181100Paint & FinishMaterialHRS$856.355PO-039
ITM-00119Cabinets & Countertops Specification 1191200Cabinets & CountertopsLaborBOX$568.215PO-040
ITM-00120Sitework & Excavation Specification 1200100Sitework & ExcavationSubcontractEA$35.5810PO-001
ITM-00121Foundation & Concrete Specification 1210200Foundation & ConcreteMaterialLF$308.605PO-002
ITM-00122Framing & Timber Specification 1220300Framing & TimberLaborSF$804.705PO-003
ITM-00123Roofing & Siding Specification 1230400Roofing & SidingSubcontractCY$38.075PO-004
ITM-00124Plumbing Rough-In Specification 1240500Plumbing Rough-InMaterialHRS$201.795PO-005
ITM-00125Electrical & Lighting Specification 1250600Electrical & LightingLaborBOX$240.6310PO-006
ITM-00126HVAC & Insulation Specification 1260700HVAC & InsulationSubcontractEA$47.715PO-007
ITM-00127Drywall & Texturing Specification 1270800Drywall & TexturingMaterialLF$198.715PO-008
ITM-00128Interior Trim & Doors Specification 1280900Interior Trim & DoorsLaborSF$518.495PO-009
ITM-00129Flooring & Tile Specification 1291000Flooring & TileSubcontractCY$373.885PO-010
ITM-00130Paint & Finish Specification 1301100Paint & FinishMaterialHRS$94.6710PO-011
ITM-00131Cabinets & Countertops Specification 1311200Cabinets & CountertopsLaborBOX$859.465PO-012
ITM-00132Sitework & Excavation Specification 1320100Sitework & ExcavationSubcontractEA$118.185PO-013
ITM-00133Foundation & Concrete Specification 1330200Foundation & ConcreteMaterialLF$105.185PO-014
ITM-00134Framing & Timber Specification 1340300Framing & TimberLaborSF$288.115PO-015
ITM-00135Roofing & Siding Specification 1350400Roofing & SidingSubcontractCY$290.2610PO-016
ITM-00136Plumbing Rough-In Specification 1360500Plumbing Rough-InMaterialHRS$653.485PO-017
ITM-00137Electrical & Lighting Specification 1370600Electrical & LightingLaborBOX$716.955PO-018
ITM-00138HVAC & Insulation Specification 1380700HVAC & InsulationSubcontractEA$22.695PO-019
ITM-00139Drywall & Texturing Specification 1390800Drywall & TexturingMaterialLF$50.775PO-020
ITM-00140Interior Trim & Doors Specification 1400900Interior Trim & DoorsLaborSF$729.4210PO-021
ITM-00141Flooring & Tile Specification 1411000Flooring & TileSubcontractCY$776.515PO-022
ITM-00142Paint & Finish Specification 1421100Paint & FinishMaterialHRS$217.365PO-023
ITM-00143Cabinets & Countertops Specification 1431200Cabinets & CountertopsLaborBOX$802.295PO-024
ITM-00144Sitework & Excavation Specification 1440100Sitework & ExcavationSubcontractEA$733.495PO-025
ITM-00145Foundation & Concrete Specification 1450200Foundation & ConcreteMaterialLF$252.5310PO-026
ITM-00146Framing & Timber Specification 1460300Framing & TimberLaborSF$478.545PO-027
ITM-00147Roofing & Siding Specification 1470400Roofing & SidingSubcontractCY$554.305PO-028
ITM-00148Plumbing Rough-In Specification 1480500Plumbing Rough-InMaterialHRS$546.535PO-029
ITM-00149Electrical & Lighting Specification 1490600Electrical & LightingLaborBOX$178.465PO-030
ITM-00150HVAC & Insulation Specification 1500700HVAC & InsulationSubcontractEA$267.6710PO-031
ITM-00151Drywall & Texturing Specification 1510800Drywall & TexturingMaterialLF$170.595PO-032
ITM-00152Interior Trim & Doors Specification 1520900Interior Trim & DoorsLaborSF$40.155PO-033
ITM-00153Flooring & Tile Specification 1531000Flooring & TileSubcontractCY$211.225PO-034
ITM-00154Paint & Finish Specification 1541100Paint & FinishMaterialHRS$808.445PO-035
ITM-00155Cabinets & Countertops Specification 1551200Cabinets & CountertopsLaborBOX$854.3110PO-036
ITM-00156Sitework & Excavation Specification 1560100Sitework & ExcavationSubcontractEA$679.395PO-037
ITM-00157Foundation & Concrete Specification 1570200Foundation & ConcreteMaterialLF$129.945PO-038
ITM-00158Framing & Timber Specification 1580300Framing & TimberLaborSF$765.895PO-039
ITM-00159Roofing & Siding Specification 1590400Roofing & SidingSubcontractCY$173.705PO-040
ITM-00160Plumbing Rough-In Specification 1600500Plumbing Rough-InMaterialHRS$265.5510PO-001
ITM-00161Electrical & Lighting Specification 1610600Electrical & LightingLaborBOX$490.995PO-002
ITM-00162HVAC & Insulation Specification 1620700HVAC & InsulationSubcontractEA$487.785PO-003
ITM-00163Drywall & Texturing Specification 1630800Drywall & TexturingMaterialLF$620.615PO-004
ITM-00164Interior Trim & Doors Specification 1640900Interior Trim & DoorsLaborSF$118.645PO-005
ITM-00165Flooring & Tile Specification 1651000Flooring & TileSubcontractCY$523.4510PO-006
ITM-00166Paint & Finish Specification 1661100Paint & FinishMaterialHRS$347.735PO-007
ITM-00167Cabinets & Countertops Specification 1671200Cabinets & CountertopsLaborBOX$763.795PO-008
ITM-00168Sitework & Excavation Specification 1680100Sitework & ExcavationSubcontractEA$393.185PO-009
ITM-00169Foundation & Concrete Specification 1690200Foundation & ConcreteMaterialLF$310.975PO-010
ITM-00170Framing & Timber Specification 1700300Framing & TimberLaborSF$834.2310PO-011
ITM-00171Roofing & Siding Specification 1710400Roofing & SidingSubcontractCY$409.105PO-012
ITM-00172Plumbing Rough-In Specification 1720500Plumbing Rough-InMaterialHRS$476.575PO-013
ITM-00173Electrical & Lighting Specification 1730600Electrical & LightingLaborBOX$820.585PO-014
ITM-00174HVAC & Insulation Specification 1740700HVAC & InsulationSubcontractEA$703.795PO-015
ITM-00175Drywall & Texturing Specification 1750800Drywall & TexturingMaterialLF$124.0710PO-016
ITM-00176Interior Trim & Doors Specification 1760900Interior Trim & DoorsLaborSF$106.235PO-017
ITM-00177Flooring & Tile Specification 1771000Flooring & TileSubcontractCY$17.425PO-018
ITM-00178Paint & Finish Specification 1781100Paint & FinishMaterialHRS$169.585PO-019
ITM-00179Cabinets & Countertops Specification 1791200Cabinets & CountertopsLaborBOX$814.265PO-020
ITM-00180Sitework & Excavation Specification 1800100Sitework & ExcavationSubcontractEA$627.0810PO-021
5,000 rows

0 cells saved

Documentation

EditSettings, EditMode, the editing parameters of GridColumn and the edit events on GridControlEvents are still to be written from Grid/EditSettings.cs, Grid/GridColumn.cs and Grid/GridControlEvents.cs.

An unhandled error has occurred. Reload 🗙

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.