学步园

#region dataset,datatable,datarow复制
IDbService item_dbservice = DbService.GetInstance();
string s_sqlstring = "select MenuName,MenuText,PicName,EventName,AuthName from adToolBar";
DataSet dset_source = item_dbservice.GetDataSet(s_sqlstring);
DataTable table_source = dset_source.Tables[0];

//dataset
//复制表结构
DataSet dset_target1 = dset_source.Clone();
//复制所有数据
DataSet dset_target2 = dset_source.Copy();

//datatable
DataTable table_target1 = table_source.Clone();
DataTable table_target2 = table_source.Copy();

//datarow
//importrow方式1
DataTable table_target3 = table_source.Clone();
foreach (DataRow row in table_source.Rows)
{
    table_target3.ImportRow(row);
}

//行列循环方式
DataTable table_target4 = table_source.Clone();
foreach (DataRow row in table_source.Rows)
{
    DataRow row_add = table_target4.NewRow();
    foreach (DataColumn column in table_source.Columns)
    {
        row_add[column.ColumnName] = row[column.ColumnName];
    }
    table_target4.Rows.Add(row_add);
}

//ItemArray方式
DataTable table_target5 = table_source.Clone();
foreach (DataRow row in table_source.Rows)
{
    DataRow row_add = table_target5.NewRow();
    row_add.ItemArray = row.ItemArray;
    table_target5.Rows.Add(row_add);
}

 

//可以排序datatable的方式 add by Vincent.Q 09.12.19

//好处:可以对数据源进行排序等操作

DataView view_first = table_menubar.DefaultView;

view_first.Sort = "SortOrder asc"

DataTable table_first = view_first.ToTable();

 

#endregion