here are parts of my used code:
using System;
using System.Componen tModel;
using System.Drawing;
using System.Collecti ons;
using System.Windows. Forms;
using System.Data;
using System.Globaliz ation;
.....
private System.Windows. Forms.DataGridT extBoxColumn
dataGridTextBox Column1;
private System.Windows. Forms.DataGrid dataGrid1;
private System.Data.Dat aSet myDataSet;
....
private void MakeDataTables( )
{
// Run all of the functions.
MakeParentTable ();
MakeChildTable( );
MakeDataRelatio n();
BindToDataGrid( );
}
private void MakeParentTable ()
{
// Create a new DataTable.
System.Data.Dat aTable myDataTable = new DataTable
("ParentTable") ;
// Declare variables for DataColumn and DataRow objects.
DataColumn myDataColumn;
DataRow myDataRow;
myDataColumn = new DataColumn();
myDataColumn.Da taType = System.Type.Get Type
("System.Int32" );
myDataColumn.Co lumnName = "id";
myDataColumn.Re adOnly = true;
myDataColumn.Un ique = true;
// Add the Column to the DataColumnColle ction.
myDataTable.Col umns.Add(myData Column);
// Create second column.
myDataColumn = new DataColumn();
myDataColumn.Da taType = System.Type.Get Type
("System.String ");
myDataColumn.Co lumnName = "ParentItem ";
myDataColumn.Au toIncrement = false;
myDataColumn.Ca ption = "ParentItem ";
myDataColumn.Re adOnly = false;
myDataColumn.Un ique = false;
// Add the column to the table.
myDataTable.Col umns.Add
(myDataColumn);
// Make the ID column the primary
key column.
DataColumn[] PrimaryKeyColum ns =
new DataColumn[1];
PrimaryKeyColum ns[0] =
myDataTable.Col umns["id"];
myDataTable.Pri maryKey =
PrimaryKeyColum ns;
// Instantiate the DataSet
variable.
myDataSet = new DataSet();
// Add the new DataTable to the
DataSet.
myDataSet.Table s.Add(myDataTab le);
// Create three new DataRow
objects and add them to the DataTable
for (int i = 0; i<= 2; i++)
{
myDataRow =
myDataTable.New Row();
myDataRow["id"] = i;
myDataRow["ParentItem "]
= "ParentItem " + i;
myDataTable.Row s.Add
(myDataRow);
}
}
private void MakeChildTable( )
{
// Create a new DataTable.
DataTable myDataTable = new
DataTable("chil dTable");
DataColumn myDataColumn;
DataRow myDataRow;
// Create first column and add to
the DataTable.
myDataColumn = new DataColumn();
myDataColumn.Da taType=
System.Type.Get Type("System.In t32");
myDataColumn.Co lumnName
= "ChildID";
myDataColumn.Au toIncrement = true;
myDataColumn.Ca ption = "ID";
myDataColumn.Re adOnly = true;
myDataColumn.Un ique = true;
// Add the column to the
DataColumnColle ction.
myDataTable.Col umns.Add
(myDataColumn);
// Create second column.
myDataColumn = new DataColumn();
myDataColumn.Da taType=
System.Type.Get Type("System.St ring");
myDataColumn.Co lumnName
= "ChildItem" ;
myDataColumn.Au toIncrement =
false;
myDataColumn.Ca ption
= "ChildItem" ;
myDataColumn.Re adOnly = false;
myDataColumn.Un ique = false;
myDataTable.Col umns.Add
(myDataColumn);
// Create third column.
myDataColumn = new DataColumn();
myDataColumn.Da taType=
System.Type.Get Type("System.In t32");
myDataColumn.Co lumnName
= "ParentID";
myDataColumn.Au toIncrement =
false;
myDataColumn.Ca ption = "ParentID";
myDataColumn.Re adOnly = false;
myDataColumn.Un ique = false;
myDataTable.Col umns.Add
(myDataColumn);
myDataSet.Table s.Add(myDataTab le);
// Create three sets of DataRow
objects, five rows each, and add to DataTable.
for(int i = 0; i <= 4; i ++)
{
myDataRow =
myDataTable.New Row();
myDataRow["childID"] = i;
myDataRow["ChildItem"]
= "Item " + i;
myDataRow["ParentID"] =
0 ;
myDataTable.Row s.Add
(myDataRow);
}
for(int i = 0; i <= 4; i ++)
{
myDataRow =
myDataTable.New Row();
myDataRow["childID"] = i
+ 5;
myDataRow["ChildItem"]
= "Item " + i;
myDataRow["ParentID"] =
1 ;
myDataTable.Row s.Add
(myDataRow);
}
for(int i = 0; i <= 4; i ++)
{
myDataRow =
myDataTable.New Row();
myDataRow["childID"] = i
+ 10;
myDataRow["ChildItem"]
= "Item " + i;
myDataRow["ParentID"] =
2 ;
myDataTable.Row s.Add
(myDataRow);
}
}
private void MakeDataRelatio n()
{
// DataRelation requires two
DataColumn (parent and child) and a name.
DataRelation myDataRelation;
DataColumn parentColumn;
DataColumn childColumn;
parentColumn = myDataSet.Table s
["ParentTabl e"].Columns["id"];
childColumn = myDataSet.Table s
["ChildTable "].Columns["ParentID"];
myDataRelation = new DataRelation
("parent2Child" , parentColumn, childColumn);
myDataSet.Table s
["ChildTable "].ParentRelation s.Add(myDataRel ation);
}
private void BindToDataGrid( )
{
// Instruct the DataGrid to bind
to the DataSet, with the
// ParentTable as the topmost
DataTable.
dataGrid1.SetDa taBinding
(myDataSet,"Par entTable");
}
it's the same code from the help-file
and the effect is that the the method "SetDataBinding " is
not known for my datagrid
thanks for your help
it's also possibe to anwer me to my email adress
-----Original Message-----
Please post part of your code.
Tu-Thach
-----Original Message-----
I'm using windows forms!
-----Original Message-----
Are you using ASP.NET or Windows Form? Only Windows
FormsDataGrid support that method.
Tu-Thach
-----Original Message-----
I'm using the following codesample:
myDataGrid. SetDataBinding( myDataSet, "Customers" );
I used the code example from the Microsoft .NET help
filebut the interesting thing is, that the
method "SetDataBinding " is unknown!
Is it possible, that something is missing or wrong in
myinstallatio n?
please can you help me?
Thanks...
.
.
.
.
