Expand Minimize

DataGridView.DataMember Property

Gets or sets the name of the list or table in the data source for which the DataGridView is displaying data.

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

public string DataMember { get; set; }

Property Value

Type: System.String
The name of the table or list in the DataSource for which the DataGridView is displaying data. The default is Empty.

ExceptionCondition
Exception

An error occurred in the data source and either there is no handler for the DataError event or the handler has set the DataGridViewDataErrorEventArgs.ThrowException property to true. The exception object can typically be cast to type FormatException.

This property is useful when binding to a data source that contains multiple lists or tables. You do not need to set this property when binding to a data source that contains a single list or table. For example, you can bind a DataGridView control to a DataSet that contains a single table without setting this property. If the DataSet contains multiple tables, however, you must set this property to the name of one of the tables.

The following code example illustrates a common use for this property. In the example, a DataGridView control named customersDataGridView is bound to a DataSet named customersDataSet. This DataSet contains a table named "Customers". The DataMember property is set to the name of the table.

private void BindData()
{
    customersDataGridView.AutoGenerateColumns = true;
    customersDataGridView.DataSource = customersDataSet;
    customersDataGridView.DataMember = "Customers";
}

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

.NET Framework

Supported in: 3.5, 3.0, 2.0
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft