DataRow[] dr_VD = dt.Select("RoomStatusCode = 'VD'", "RoomNo");
DataTable dt = dr_VD.
CopyToDataTable();//转换为DataTable
第一种:
//将DataTable克隆,后直接添加DataRow[] 这是数组
DataTable dt_VD1 = dt.Clone();
dt_VD1.TableName = "VD";
foreach (DataRow dr in dr_VD)
{
dt_VD1.ImportRow(dr);
}
第二种:
//添加列,并且添加数据
DataTable dt_VD = new DataTable();
dt_VD.TableName = "VD";
dt_VD.Columns.Add("RoomNo");
DataRow newRow_VD;
foreach (DataRow dr in dr_VD)
{
newRow_VD =
dt_VD.NewRow(); //DataRow是不能直接New的
newRow_VD["RoomNo"] = dr["RoomNo"].ToString();
dt_VD.Rows.Add(newRow_VD);
}
第三种:
DataRow row = Member_Dal.GetFoodInfoByFoodId(listForFoodId[i]).
Rows[0];
dtOrder.Rows.Add(
row.ItemArray);//datatable中添加row