DataGridView::CellContextMenuStripNeeded Event


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

Occurs when a cell's shortcut menu is needed.

Namespace:   System.Windows.Forms
Assembly:  System.Windows.Forms (in System.Windows.Forms.dll)

event DataGridViewCellContextMenuStripNeededEventHandler^ CellContextMenuStripNeeded {
	void add(DataGridViewCellContextMenuStripNeededEventHandler^ value);
	void remove(DataGridViewCellContextMenuStripNeededEventHandler^ value);

The CellContextMenuStripNeeded event occurs only when the DataGridView control DataSource property is set or its VirtualMode property is true.

When you handle the CellContextMenuStripNeeded event, the shortcut menu that you specify in the handler is shown whenever the user right-clicks a cell. This is useful when you want to display a shortcut menu determined by the current state or value of a cell.

The CellContextMenuStripNeeded event also occurs whenever the value of the DataGridViewCell::ContextMenuStrip property is retrieved, either programmatically or when the user right-clicks a cell.

You can use the DataGridViewCellEventArgs::ColumnIndexand RowIndex properties to determine the state or value of a cell, and use this information to change or modify the DataGridViewCellContextMenuStripNeededEventArgs::ContextMenuStrip property. This property is initialized with the value of the cell ContextMenuStrip property, which the event value overrides.

Handle the CellContextMenuStripNeeded event when working with large amounts of data to avoid the performance penalties of setting the cell ContextMenuStrip value for multiple cells. For more information, see Best Practices for Scaling the Windows Forms DataGridView Control.

You can also specify shortcut menus for individual rows rather than individual cells by setting the row ContextMenuStrip property or handling the RowContextMenuStripNeeded event. The cell ContextMenuStrip property setting overrides the row ContextMenuStrip property setting, and the CellContextMenuStripNeeded event overrides both the RowContextMenuStripNeeded event and the row ContextMenuStrip property setting. However, you can specify null for a cell shortcut menu to prevent a row shortcut menu from being overridden.

For more information about handling events, see NIB: Consuming Events.

The following code example demonstrates how to use aCellContextMenuStripNeeded event handler to display a custom shortcut menu used when the user right-clicks a cell.

ToolStripMenuItem^ wholeTable;
ToolStripMenuItem^ lookUp;
System::Windows::Forms::ContextMenuStrip^ strip;
String^ cellErrorText;

void dataGridView1_CellContextMenuStripNeeded( Object^ /*sender*/,
    DataGridViewCellContextMenuStripNeededEventArgs^ e )
    cellErrorText = String::Empty;
    if ( strip == nullptr )
        strip = gcnew System::Windows::Forms::ContextMenuStrip;
        lookUp->Text = L"Look Up";
        wholeTable->Text = L"See Whole Table";
        strip->Items->Add( lookUp );
        strip->Items->Add( wholeTable );

    e->ContextMenuStrip = strip;

void wholeTable_Click( Object^ /*sender*/, EventArgs^ /*e*/ )
    dataGridView1->DataSource = Populate( L"Select * from employees", true );

DataGridViewCellEventArgs^ theCellImHoveringOver;
void dataGridView1_CellMouseEnter( Object^ /*sender*/, DataGridViewCellEventArgs^ e )
    theCellImHoveringOver = e;

DataGridViewCellEventArgs^ cellErrorLocation;
void lookUp_Click( Object^ /*sender*/, EventArgs^ /*e*/ )
        dataGridView1->DataSource = Populate( String::Format( L"Select * from employees where {0} = '{1}'", dataGridView1->Columns[ theCellImHoveringOver->ColumnIndex ]->Name, dataGridView1->Rows[ theCellImHoveringOver->RowIndex ]->Cells[ theCellImHoveringOver->ColumnIndex ]->Value ), true );
    catch ( ... ) 
        cellErrorText = L"Can't look this cell up";
        cellErrorLocation = theCellImHoveringOver;


void dataGridView1_CellErrorTextNeeded( Object^ /*sender*/, DataGridViewCellErrorTextNeededEventArgs^ e )
    if ( cellErrorLocation != nullptr )
        if ( e->ColumnIndex == cellErrorLocation->ColumnIndex && e->RowIndex == cellErrorLocation->RowIndex )
            e->ErrorText = cellErrorText;

DataTable^ Populate( String^ query, bool resetUnsharedCounter )
    if ( resetUnsharedCounter )

    // Alter the data source as necessary
    SqlDataAdapter^ adapter = gcnew SqlDataAdapter( query,
        gcnew SqlConnection( L"Integrated Security=SSPI;Persist Security Info=False;"
        L"Initial Catalog=Northwind;Data Source= localhost" ) );
    DataTable^ table = gcnew DataTable;
    adapter->Fill( table );
    return table;

Label^ count;
int unsharedRowCounter;
void ResetCounter()
    unsharedRowCounter = 0;
    count->Text = unsharedRowCounter.ToString();

.NET Framework
Available since 2.0
Return to top