循环中的数据视图行过滤器

发布于 2024-11-28 02:29:07 字数 568 浏览 1 评论 0原文

        DataTable Table = new DataTable();
        DataRow row;
        try
        {
            row = Value.NewRow();
            for (int i = 0; i < Value.Rows.Count; i++)
            {
                TableNm = new DataView(DB.Tables[1]);
                TableNm.RowFilter = "name = " + "'" +""+Value.Rows[i][0].ToString()+"" + "'" + "";
                row[i] = (TableNm.ToTable()).Rows;
            }
            Table.Rows.Add(row);

对于上述情况，我正在尝试过滤多个值并在数据表中绑定或添加行，但它对 for 循环中的 dataview rowfilter 没有任何建议其中每个 Rowfilter 每次仅返回一行

原文

        DataTable Table = new DataTable();
        DataRow row;
        try
        {
            row = Value.NewRow();
            for (int i = 0; i < Value.Rows.Count; i++)
            {
                TableNm = new DataView(DB.Tables[1]);
                TableNm.RowFilter = "name = " + "'" +""+Value.Rows[i][0].ToString()+"" + "'" + "";
                row[i] = (TableNm.ToTable()).Rows;
            }
            Table.Rows.Add(row);

For The Above I am Trying to Filter Multiple value and Bind or add row in data table But it's not working any suggestion for dataview rowfilter in for loop
where every Rowfilter return only one row every time

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

晨曦÷微暖 2024-12-05 02:29:07

这是一个真正的问题，您可以先添加动态列，而不是尝试 row.add() 的 row.add(row item arry) 瞬间，

就像

 DataTable Table = new DataTable();
    DataRow row;
    try
    {
//Add column here

        row = Value.NewRow();
        for (int i = 0; i < Value.Rows.Count; i++)
        {
            TableNm = new DataView(DB.Tables[1]);
            TableNm.RowFilter = "name = " + "'" +""+Value.Rows[i][0].ToString()+"" + "'" + "";
            row[i] = (TableNm.ToTable()).Rows;
        }
        Table.Rows.Add(row.ItemArray);

It's a real problem you can add Dynamically column first than try row.add(row item arry) instant of row.add()

just like

 DataTable Table = new DataTable();
    DataRow row;
    try
    {
//Add column here

        row = Value.NewRow();
        for (int i = 0; i < Value.Rows.Count; i++)
        {
            TableNm = new DataView(DB.Tables[1]);
            TableNm.RowFilter = "name = " + "'" +""+Value.Rows[i][0].ToString()+"" + "'" + "";
            row[i] = (TableNm.ToTable()).Rows;
        }
        Table.Rows.Add(row.ItemArray);

回复收藏 0 原文

~没有更多了~