注册 登录
编程论坛 VB.NET论坛

datatable 的问题

jack_xu2046 发布于 2010-10-13 20:04, 728 次点击
For Pncount = 0 To dtPN.Rows.Count - 1
                AllModel(Pncount) = dtPN.Rows(Pncount).Item("PN").ToString()
                For i As Integer = 0 To lstStepSearch.Items.Count - 1
                    dr = dt_All.NewRow
                    dr(0) = lstStepSearch.Items(i).Value

                    ' Total count
                        sql = New OleDb.OleDbCommand("xx", dBconn)
                    dBadapter.SelectCommand = sql
                    ds = New DataSet
                    dBadapter.Fill(ds)
                    dr(1) = ds.Tables(0).Rows.Count

                    'Pass Count

                        sql = New OleDb.OleDbCommand("xx"dBconn)
                    dBadapter.SelectCommand = sql
                    ds = New DataSet
                    dBadapter.Fill(ds)
                    dr(2) = ds.Tables(0).Rows.Count

                    'FAIL Count

                        sql = New OleDb.OleDbCommand("xx"dBconn)
                    dBadapter.SelectCommand = sql
                    ds = New DataSet
                    dBadapter.Fill(ds)
                    dr(3) = ds.Tables(0).Rows.Count


                    dt_All.Rows.Add(dr)
                         Next

            Next

            ds = New DataSet
            ds.Tables.Add(dt_All)
            gvYieldAll.DataSource = ds.Tables(0)
            gvYieldAll.DataBind()

以上是程序中的一段
其实我这个是统计数据用的
外循环是MODEL
内循环是Step

第一次得到外循环中会得到Model1的
Step1 总共 ,好,坏
step2 总共, 好,坏   这样的数据
我想要的结果是让Model2,Model3,Model4……的
Step1与Step2数据与Model1的累计起来

其实就是想得到这样的结果
Step1 ,Model1.总共+Model2.总共…… ,Model1.好+Model2.好……,Model1.坏+Model2.坏
Step2 ,Model1.总共+Model2.总共…… ,Model1.好+Model2.好……,Model1.坏+Model2.坏

我对datatable这地方不怎么熟悉,不知道怎样将数据累加起来?


[ 本帖最后由 jack_xu2046 于 2010-10-13 20:16 编辑 ]
1 回复
#2
jack_xu20462010-10-13 20:17
dr = dt_All.NewRow
这个地方我可以加个判断Pncount 不等于0时
不让新建ROW

但下面怎么处理 这句 dt_All.Rows.Add(dr)
1