| VSFlexGrid Introduction > Data Binding (ADO and DAO) > Other types of Data Binding > Binding to Variant arrays |
Binding to arrays is useful when the data you want to display is already stored in an array, so you don't have to copy it back and forth between the control and the array, when you want to connect several grids to a single array, or when you have three-dimensional arrays and want to use the VSFlexGrid to view the array "page by page".
To bind the VSFlexGrid to an array, use the BindToArray method and pass a Variant array as the first parameter. The grid will display values from the array and automatically write any modifications back into the array. If you make changes to the array in code, however, you must call the grid's Refresh method to make them visible to the user.
The parameters on the BindToArray method allow you to control how the rows and columns map onto the array's dimensions, so you can easily transpose the array. The mapping always spans the entire array, however. If you want to hide some rows or columns, set their height or width to zero. The binding does not apply to fixed rows or columns. It works only on the scrollable part of the control.