privatevoid MakeDataTableAndDisplay() { // Create new DataTable. DataTable table =new DataTable("table"); // Declare DataColumn and DataRow variables. DataColumn column; DataRow row; // Create new DataColumn, set DataType, // ColumnName and add to DataTable. column =new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.ColumnName ="id"; table.Columns.Add(column); // Create second column. column =new DataColumn(); column.DataType = Type.GetType("System.String"); column.ColumnName ="item"; table.Columns.Add(column); // Create new DataRow objects and add to DataTable. for(int i =0; i <10; i++) { row = table.NewRow(); row["id"] = i; row["item"] ="item "+ i; table.Rows.Add(row); } // Set to DataGrid.DataSource property to the table. dataGrid1.DataSource = table; }
将 DataTable 保存到 DataSet 中所需的 C# 代码:void DataTableToDataSet(DataTable dt) { // Duplicate the table and add it to a DataSet DataSet dsTmp =new DataSet(); DataTable dtTmp = dt.Copy(); dsTmp.Tables.Add(dtTmp); } 将DataView保存到DataSet中:void DataViewToDataSet(DataView dv) { // Clone the structure of the table behind the view DataTable dtTemp = dv.Table.Clone(); dtTemp.TableName ="Row"; // Populate the table with rows in the view foreach(DataRowView drv in dv) dtTemp.ImportRow(drv.Row); DataSet dsTemp =new DataSet(dv.Table.TableName); // Add the new table to a DataSet dsTemp.Tables.Add(dtTemp); }