3.2 Basic Grid Tasks

You can change the number of rows and columns in two ways:

• Modify the appropriate grid properties from the form designer (this section)

  This technique sets the initial size of your grid (what appears when you launch your program).

• Call the grid API directly from within your program (Section 3.2.2)

  This technique allows you to change the size of the grid any time after program start up.

To modify the appropriate grid properties from the form designer:

1. Right-click the form and select Properties. Then, right-click the grid and select Properties. A separate set of properties appears for each.

2. Modify the grid properties: Find ColCount and RowCount, and modify their values to 8 and 10, respectively. Press Enter. The grid in the designer shows the new sizes.

3. Build and run the application.

   Figure 5: Grid with Dimensions Set in Property Grid

   

1. In code view, find the constructor (the default name is Form1()).

2. After the call to the InitializeComponent() method, add the following code:

   // Resize the grid from the initial size to 15x10 gridControl1.RowCount = 15; gridControl1.ColCount = 10;

3. Build and run the application.

   Figure 6: Grid with Dimensions Set in Code

   

1. Click the form's title bar, and then select the Events button in the properties table (the lightning bolt). A property called Load appears under the Behavior section.

2. Type FormLoad in the value field and press Enter. A class method called FormLoad() is created. Add the following code:

   // Populate several cells Range r1 = Range.Cells(1, 1, 3, 3); Style s1 = new Style(); s1.Value = "TestData"; gridControl1.SetStyleRange(r1, s1);

3. Build and run the application.

   Figure 7: Data Stored in a Range of Cells

   

4. Add the following code right after the code fragment you added above:

   // Manipulate individual cells gridControl1[1,1].Style.Value = "This is cell (1,1)"; gridControl1[5,7].Style.Value = "This is cell (5,7)"; gridControl1[1,3].ClearValue();

5. Build and run the application.

   Figure 8: Data Stored in Individual Cells

   

When modifying multiple cells, it is a good idea to call LockUpdate() to prevent unnecessary redrawing and flickering. To call LockUpdate(), write FormLoad this way:

private void FormLoad(object sender, System.EventArgs e) { bool prevLock = gridControl1.LockUpdate(true); // Populate several cells Range r1 = Range.Cells(1, 1, 3, 3); Style s1 = new Style(); s1.Value = "TestData"; gridControl1.SetStyleRange(r1, s1); // Manipulate individual cells gridControl1[1,1].Style.Value = "This is cell (1,1)"; gridControl1[5,7].Style.Value = "This is cell (5,7)"; gridControl1[1,3].ClearValue(); gridControl1.LockUpdate(prevLock); }

You can read values from individual cells from the grid using GetValueRowCol():

// Copy the contents of (1,1) to another cell string cellValue = gridControl1.GetValueRowCol(1,1); gridControl1[8,2].Style.Value = "Value transferred from (1,1):" + cellValue;

You cannot use gridControl1[1,1] in place of gridControl1.GetValueRowCol(1,1). gridcontrol[1,1] represents a Cell object, not a Value.

Figure 9: Retrieving Values From a Grid

Copyright © Rogue Wave Software, Inc. All Rights Reserved.

The Rogue Wave name and logo, and Stingray, are registered trademarks of Rogue Wave Software. All other trademarks are the property of their respective owners.
Provide feedback to Rogue Wave about its documentation.