我想将数据行过滤器值插入到数据表新行中。我正在使用一个包含值的数据集。我用一些表达式用datarow.rowfilter过滤数据集行。现在datarow.row过滤器有一行。现在我想把那一行插入数据表,但我做不到。。请帮我做这件事。。
我的部分代码在这里。。
DV = DS.DefaultView;
DT = DS.Copy();
DT1 = DT.Clone();
foreach (DataRow dr in DS.Rows)
{
DT1.NewRow();
forward1 = Convert.ToString(dr["fldforward1"]);
forward2 = Convert.ToString(dr["fldforward2"]);
forward3 = Convert.ToString(dr["fldforward3"]);
forward4 = Convert.ToString(dr["fldforward4"]);
forward5 = Convert.ToString(dr["fldforward5"]);
string status = Convert.ToString(dr["fldstatus"]);
string date1 = Convert.ToString(dr["fldrequestdate"]);
if (" " == forward1)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "temp", "<script language='javascript'>alert('Error for reading data...');</script>", false);
}
else if ("" == forward2)
{
DV.RowFilter = "fldforward1='" + forward1 + "' and fldstatus='Pending' and fldrequestdate='" + date1 + "'";
// DT1.Rows.Add(DV); //DV.RowFilter having a row . I want to insert to datatable DT1 row
}
}
请帮我做这个。。。。
如果您确定只有一行,那么您可以使用
DT1.ImportRow(DS.Select("fldforward1='" + forward1 + "' and fldstatus='Pending' and fldrequestdate='" + date1 + "'")[0]);