DataMember Property (SheetView) | Spread Windows Forms 13.0 Product Documentation

DataMember Property (SheetView)

In This Topic

Gets or sets the name of the data member that populates the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property DataMember As String

'Usage
 
Dim instance As SheetView
Dim value As String
 
instance.DataMember = value
 
value = instance.DataMember

public string DataMember {get; set;}

Property Value

String containing the name of the database member

Exceptions

Exception	Description
System.InvalidOperationException	Data model does not support IDataSourceSupport interface

Example

This example sets the data member and data source for a bound spreadsheet.

string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source= " & Application.StartupPath + "\\Patients2000.mdb";
string sqlStr = "SELECT * FROM Patients"; 
System.Data.OleDb.OleDbConnection conn  = new System.Data.OleDb.OleDbConnection(conStr); 
DataSet ds = new DataSet(); 
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn);
fpSpread1.ActiveSheet.DataAutoSizeColumns = true; 
fpSpread1.ActiveSheet.DataMember = "Patients"; 
da.Fill(ds); 
fpSpread1.ActiveSheet.DataSource = ds;

Visual Basic

Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source= " + Application.StartupPath & "\Patients2000.mdb"
Dim sqlStr As String = "SELECT * FROM Patients"
Dim conn As New System.Data.OleDb.OleDbConnection(conStr)
Dim ds As DataSet = New DataSet()
Dim da As New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn)
FpSpread1.ActiveSheet.DataAutoSizeColumns = True
FpSpread1.ActiveSheet.DataMember = "Patients"
da.Fill(ds)
FpSpread1.ActiveSheet.DataSource = ds

Reference

SheetView Class
SheetView Members

User-Task Documentation

Managing Data Binding

Product Support Forum | Print this page