public DataTable Newds(DataSet dsSource)
{
DataTable dn = dsSource.Tables[0];
DataTable da = GetYiZhuFeiYong(DangAnId).Tables[0];
DataTable dtNewHuiZong = dn.Copy();
for (int i = 0; i < dn.Rows.Count; i++)
{
int index = 0;
for (int j = 0; j < da.Rows.Count; j++)
{
DataRow dnNew = dtNewHuiZong.NewRow();
if (dn.Rows[i]["yizhuid"].ToString() == da.Rows[j]["yizhuid"].ToString())
{
if (index == 0)
{
//dtNewHuiZong.PrimaryKey = new System.Data.DataColumn[] { dtNewHuiZong.Columns["yizhuid"] };
System.Data.DataRow row = dtNewHuiZong.Rows.Find(dn.Rows[i]["yizhuid"].ToString());
dtNewHuiZong.Rows.Remove(row);
}
dnNew["XiangMuMingCheng"] = da.Rows[j]["mingcheng"].ToString();
dnNew["GuiGe"] = " ";
dnNew["JiLiang"] = " ";
dnNew["YongFa"] = " ";
dnNew["DCRenYuan"] = " ";
dnNew["ColSpan"] = dn.Rows[i]["ColSpan"].ToString();
dnNew["PinCi"] = "<span style='color:red'>" + da.Rows[j]["shuliang"].ToString() + "</span>";
dnNew["JinE"] = " ";
dnNew["Display"] = "display:none;";
dnNew["DisplayChangQi"] = "display:none;";
dnNew["XiaDaNianYueRi"] = dn.Rows[i]["XiaDaNianYueRi"].ToString();
dnNew["XiaDaYueRi"] = dn.Rows[i]["XiaDaYueRi"].ToString();
dnNew["XiaDaShi"] = dn.Rows[i]["XiaDaShi"].ToString();
dnNew["ZhiXingYueRi"] = dn.Rows[i]["ZhiXingYueRi"].ToString();
dnNew["XiaDaYiSheng"] = dn.Rows[i]["XiaDaYiSheng"].ToString();
dnNew["ZhiXingShi"] = dn.Rows[i]["ZhiXingShi"].ToString();
dnNew["ZhiXingHuShi"] = dn.Rows[i]["ZhiXingHuShi"].ToString();
dnNew["TingZhiYueRi"] = dn.Rows[i]["TingZhiYueRi"].ToString();
dnNew["TingZhiShi"] = dn.Rows[i]["TingZhiShi"].ToString();
dnNew["TingZhiYiSheng"] = dn.Rows[i]["TingZhiYiSheng"].ToString();
dnNew["TingZhiHuShi"] = dn.Rows[i]["TingZhiHuShi"].ToString();
//dnNew["yizhuid"] = da.Rows[j]["yizhuid"].ToString();
dtNewHuiZong.Rows.InsertAt(dnNew, 1);
index++;
continue;
}
}
}
//for (int i = dtNewHuiZong.Rows.Count - 2; i > 0; i--)
//{
// DataRow[] rows = dtNewHuiZong.Select(string.Format("{0}='{1}'", "yizhuid", dtNewHuiZong.Rows[i]["yizhuid"].ToString()));
// if (rows.Length > 1)
// {
// dtNewHuiZong.Rows.RemoveAt(i);
// }
//}
DataView dw = dtNewHuiZong.DefaultView;
dw.Sort = " XiaDaNianYueRi desc, XiaDaShi desc";
dtNewHuiZong = dw.ToTable();
return dtNewHuiZong;
}
附上代碼,說下邏輯,就是現在根據第一個datatable的一列值回圈添加出一個新的datatable,但是現在要把這個新的datatable只顯示新的值,第一個資料表的值要洗掉掉,各位大神能不能提供下思路,或者建議,PS:目前的寫法有誤
uj5u.com熱心網友回復:
這.... 代碼 這....描述 為什么語言傳達不了資訊?轉載請註明出處,本文鏈接:https://www.uj5u.com/net/284052.html
標籤:C#
上一篇:c#用HttpWebRequest發送https請求時,如何添加ssl層握手包的header頭里的User-Agent?
下一篇:C# div間隔展示內容
