DataGridView (dgr)

DataGrid (dgr) - Allows the user to display (and edit) a table of information.

Properties

AllowDrop	Whether the control can accept data that is dragged and dropped onto this control.
AllowUserToAddRows	Gets or sets the option for the user to add rows
AllowUserToDeleteRows	Gets or sets the option for the user to delete rows
AllowUserToOrderColumns	Gets or sets the option for the user to reorder the columns
AllowUserToResizeColumns	Gets or sets the option for the user to adjust the column widths
AllowUserToResizeRows	Gets or sets the option for the user to adjust the row heights
AlternatingRowsDefaultCellStyle	Only for rows with odd index numbers
AutoGenerateColumns	When you bind a DataGridView control you can set this property to true for the column types to be automatically generated which are appropriate for the data type in the bound source.
AutoSizeColumnsMode	Indicates how column widths are determined.
BackgroundColor	Gets or sets the color of the non-row area of the grid. This is always set to Window.
BorderStyle	Gets or sets the grid's border style.
CellBorderStyle	Gets or sets the cell border style
ClipboardCopyMode
ColumnHeadersBorderStyle
ColumnHeadersDefaultCellStyle
ColumnHeadersHeight	20
ColumnHeadersHeightSizeMode	DisableResizing
ColumnHeadersVisible	Gets or sets a value indicating whether the column headers a table are visible.
Columns
ContextMenuStrip
CurrentCell	Gets or sets which cell has the focus. Not available at design time.
CurrentRowIndex	Gets or sets index of the selected row.
DataMember	Gets or sets the specific list in a DataSource for which the System.Windows.Forms.DataGrid control displays a grid.
DataSource	Gets or sets the data source that the grid is displaying data for.
DefaultCellStyle
EditMode
EnableHeadersVisibleStyles
FirstVisibleColumn	Gets the index of the first visible column in a grid.
FlatMode	Gets or sets a value indicating whether the grid displays in flat mode.
ForeColor	Overridden. Gets or sets the foreground color (typically the color of the text) property of the System.Windows.Forms.DataGrid control.
GenerateMember
GridColor
GridLineColor	Gets or sets the color of the grid lines.
GridLineStyle	Gets or sets the line style of the grid.
HeaderBackColor	Gets or sets the background color of all row and column headers.
HeaderFont	Gets or sets the font used for column headers.
HeaderForeColor	Gets or sets the foreground color of headers.
LinkColor	Gets or sets the color of the text that you can click to navigate to a child table.
LinkHoverColor	Gets or sets the color a link changes to when the mouse pointer moves over it.
Margin
MultiSelect
ParentRowsBackColor	Gets or sets the background color of parent rows.
ParentRowsForeColor	Gets or sets the foreground color of parent rows.
ParentRowsLabelStyle	Gets or sets the way parent row labels are displayed.
ParentRowsVisible	Gets or sets a value indicating whether the parent rows of a table are visible.
PreferredColumnWidth	Gets or sets the default width of the grid columns in pixels.
PreferredRowHeight	Gets or sets the preferred row height for the System.Windows.Forms.DataGrid control.
ReadOnly	Gets or sets a value indicating whether the grid is in read-only mode.
RowHeadersBorderStyle
RowHeadersDefaultCellStyle
RowHeadersVisible	Gets or sets a value that specifies whether row headers are visible.
RowHeadersWidth	Gets or sets the width of row headers.
RowHeadersWidthSizeMode
RowsDefaultCellStyle
ScrollBars	Indicates the type of scroll bars that are displayed: None, Horizontal, Vertical or Both. The scroll bars will only appear when they are needed and not all the time. If you want them to appear all the time then you must derive you own class.
SelectionMode	FullRowSelect
ShowCellErrors
ShowCellToolTips	False
ShowEditingIcon
ShowRowErrors
Size
StandardTab	Setting this to True prevents the tab key from being used to move the focus to the next cell.
TabIndex
TabStop
Tag
UseWaitCursor
VirtualMode
Visible

Methods

BeginEdit	Attempts to put the grid into a state where editing is allowed.
BeginInit	Begins the initialization of a System.Windows.Forms.DataGrid that is used on a form or used by another component. The initialization occurs at run time.
ClearSelection
Collapse	Collapses child relations, if any exist for all rows, or for a specified row.
EndEdit	Requests an end to an edit operation taking place on the System.Windows.Forms.DataGrid control.
EndInit	Ends the initialization of a System.Windows.Forms.DataGrid that is used on a form or used by another component. The initialization occurs at run time.
Expand	Displays child relations, if any exist, for all rows or a specific row.
GetCellBounds	Overloaded. Gets the Rectangle that specifies the four corners of a cell.
GetCurrentCellBounds	Gets a Rectangle that specifies the four corners of the selected cell.
HitTest	Overloaded. Gets information about the System.Windows.Forms.DataGrid control at a specified point on the screen.
IsExpanded	Gets a value that indicates whether a specified row's node is expanded or collapsed.
IsSelected	Gets a value indicating whether a specified row is selected.
Item	Overloaded. Gets or sets the value of a specified cell.
NavigateBack	Navigates back to the table previously displayed in the grid.
NavigateTo	Navigates to the table specified by row and relation name.
ResetAlternatingBackColor	Resets the AlternatingBackColor property to its default color.
ResetBackColor	Overridden. Resets the BackColor property to its default value.
ResetForeColor	Overridden. Resets the ForeColor property to its default value.
ResetGridLineColor	Resets the GridLineColor property to its default value.
ResetHeaderBackColor	Resets the HeaderBackColor property to its default value.
ResetHeaderFont	Resets the HeaderFont property to its default value.
ResetHeaderForeColor	Resets the HeaderForeColor property to its default value.
ResetLinkColor	Resets the LinkColor property to its default value.
ResetSelectionBackColor	Resets the SelectionBackColor property to its default value.
ResetSelectionForeColor	Resets the SelectionForeColor property to its default value.
Select	Overloaded. Selects a specified row.
SetDataBinding	Sets the DataSource and DataMember properties at run time.
UnSelect	Unselects a specified row.

Events

CellClick	Occurs when any part of a cell is clicked by using the mouse. This is required if selection has been removed from the control and you need to know when focus comes back to this control.
CellBeginEdit
CellEndEdit
CellEnter	Occurs when the current cell changes or when the control receives input focus.
CellFormatting	Occurs when the contents of a cell need to be formatted for display.
CellValidated	Occurs after the cell has finished validating.
CellValidating	Occurs when a cell loses input focus, enabling content validation.
CurrentCellChanged	Occurs when the CurrentCell property changes. This is fired when both arrow keys or mouse are used.
EditingControlShowing	Occurs when a control for editing a cell is showing.
RowEnter	Occurs when the current row is changed
SelectionChanged	Occurs when the current selection changes.
TextChanged

Defining and Populating a DataGridView

Dim ascolumnsarray As String(,) 

'create the application DataSet
clsDataSet.mobjDataSet = New System.Data.DataSet() 

clsDataSet.mobjDataSet.Tables.Add(New System.Data.DataTable("Worksheets")) 

ascolumnsarray = DataGridWorksheets_DefineColumns() 
Call clsDataTable.DefineColumns(Me.dgrWorksheets, "Worksheets", ascolumnsarray) 

Call DataGridWorksheets_TablePopulate() 

Call clsDataGrid.ViewCreate(Me.dgrWorksheets, "Worksheets", True) 

Call clsDataGrid.TableStyleDefine("Worksheets", _ 
                                  Me.dgrWorksheets, _ 
                                  ascolumnsarray, _ 
                                  New clsDataGrid.DataGridFormatCellEventHandler(AddressOf DataGrid_CellFormatEvent), _ 
                                  System.Drawing.Color.DarkBlue, _ 
                                  System.Drawing.Color.White)