Gets or sets a row identifier.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property DataKeyField As Object |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As DefaultSheetDataModel
Dim value As Object
instance.DataKeyField = value
value = instance.DataKeyField |
| C# | |
|---|
public object DataKeyField {get; set;} |
Property Value
Object containing the data key
Remarks
Example
This example creates a new DefaultSheetDataModel, binds it to a database and attaches it to the DataModel of the active sheet. It does not automatically generate its columns based on the columns in the database, but does so on an individual basis.
| Visual Basic | Copy Code |
|---|
PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load
If(IsPostBack)ThenReturn
DimconStrAsString="Provider=Microsoft.JET.OLEDB.4.0;datasource=d:\\nwind.mdb"
DimsqlStrAsString="SELECT*FROMEmployees"
DimconnAsSystem.Data.OleDb.OleDbConnection=NewSystem.Data.OleDb.OleDbConnection(conStr)
DimdsAsDataSet=NewDataSet()
DimdaAsSystem.Data.OleDb.OleDbDataAdapter=NewSystem.Data.OleDb.OleDbDataAdapter(sqlStr,conn)
da.Fill(ds,"Employees")
DimdmAsNewFarPoint.Web.Spread.Model.DefaultSheetDataModel()
dm.DataSource=ds
dm.AutoGenerateColumns=False
dm.SetModelDataColumn(0,2)
dm.SetModelDataColumn(1,1)
dm.DataKeyField="LastName"
FpSpread1.ActiveSheetView.DataModel=dm
conn.Close()
ListBox1.Items.Add(dm.ColumnCount)
ListBox1.Items.Add(dm.RowCount)
EndSub |
| C# | Copy Code |
|---|
privatevoidPage_Load(objectsender,System.EventArgse)
{
stringconStr="Provider=Microsoft.JET.OLEDB.4.0;datasource=d:\\nwind.mdb";
stringsqlStr="SELECT*FROMEmployees";
System.Data.OleDb.OleDbConnectionconn=newSystem.Data.OleDb.OleDbConnection(conStr);
DataSetds=newDataSet();
System.Data.OleDb.OleDbDataAdapterda=newSystem.Data.OleDb.OleDbDataAdapter(sqlStr,conn);
da.Fill(ds,"Employees");
FarPoint.Web.Spread.Model.DefaultSheetDataModeldm=newFarPoint.Web.Spread.Model.DefaultSheetDataModel(ds,"Employees");
dm.DataSource=ds;
dm.AutoGenerateColumns=false;
dm.SetModelDataColumn(0,2);
dm.SetModelDataColumn(1,1);
dm.DataKeyField="LastName";
FpSpread1.ActiveSheetView.DataModel=dm;
conn.Close();
ListBox1.Items.Add(Convert.ToString(dm.ColumnCount));
ListBox1.Items.Add(Convert.ToString(dm.RowCount));
} |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
