Solved

Datatable not populating correctly

Posted on 2010-08-31
2
363 Views
Last Modified: 2012-05-10
Hello,

Below is code I modified from code I had used to to create a graph. I have modified to work with other code that I developed to export a graph and it's underlying dataset to an excel dataset.  as part of my testing, I added a datagridview to the calling form in order to verify that I was getting the correct values.  After executing the code, I see, that the same I am getting duplicate values.  For example for two graph object, I am getting the same results.  I'm not sure what the problem is.
Private Function CreateGraphTable(ByVal intDatasetGroupId) As DataTable
        Dim graphs As New List(Of GraphReport)
        Dim dset As New DataSet("MyDataSet")
        Dim strTitleName As String = ""
        Dim strUnits As String = ""
        Dim dpl As New List(Of DatasetPair)
        Try
            dpl = DatasetPairDB.GetExportDatasetGroupDetail(intDatasetGroupId)
            Dim objgraph As New GraphReport
            For Each dp As DatasetPair In dpl

                objgraph.DataVersionIdOne = dp.DataVersionIdOne.ToString
                objgraph.DataVersionIdTwo = dp.DataVersionIdTwo.ToString
                objgraph.MetricName = dp.MetricName.ToString
                objgraph.GraphTitle = "TEST"
                graphs.Add(objgraph)
            Next

            For Each g As GraphReport In graphs

                If MatchingMetricUnits(g) = Nothing Then
                    MessageBox.Show(g.DataVersionIdOne.ToString & " and " & g.DataVersionIdTwo.ToString & " do not have corresponding units!", "Erro")
                    Return Nothing
                    Exit Function
                Else
                    strUnits = MatchingMetricUnits(g)
                    Units = strUnits
                End If

                Dim ds As New DataTable
                ds = ReportDB.GetDeltaSeriesData(g.DataVersionIdOne, g.DataVersionIdTwo, g.MetricName)

                Dim dtgv As New DataTable
                dtgv = ReportDB.GetDeltaReportData(g.DataVersionIdOne, g.DataVersionIdTwo, g.MetricName)

                If dtgv.Rows.Count < 1 Then
                    MessageBox.Show("No Data")
                    Return Nothing
                    Exit Function
                End If

                Dim newtable As New DataTable

                dset.Tables.Add(dtgv)
                For Each table As DataTable In dset.Tables
                    newtable.Merge(table)
                Next
                dgvGraphResults.DataSource = newtable
                Me.DgvTable = newtable

                Dim strSeriesName As String = g.DataVersionIdOne.ToString & " - " & g.DataVersionIdTwo.ToString
                MySeriesName = strSeriesName

                strTitleName = g.GraphTitle.ToString
                MyMetricName = g.GraphTitle.ToString

            Next
            Return DgvTable

        Catch ex As Exception
            MessageBox.Show(ex.Message.ToString & Err.Number.ToString)
            Return Nothing
        End Try

    End Function

Open in new window

0
Comment
Question by:chtullu135
  • 2
2 Comments
 

Author Comment

by:chtullu135
ID: 33568560
Further troubleshooting revealed that the following loop is not populating objgraph properly
 dpl = DatasetPairDB.GetExportDatasetGroupDetail(intDatasetGroupId)
            Dim objgraph As New GraphReport
            For Each dp As DatasetPair In dpl

                objgraph.DataVersionIdOne = dp.DataVersionIdOne.ToString
                objgraph.DataVersionIdTwo = dp.DataVersionIdTwo.ToString
                objgraph.MetricName = dp.MetricName.ToString
                objgraph.GraphTitle = "TEST"
                graphs.Add(objgraph)
            Next
0
 

Accepted Solution

by:
chtullu135 earned 0 total points
ID: 33568658
I found the problem.  It was pretty basic.  I needed to instantiate objgraph in the first line of the for loop instead of before the start of the for loop, otherwise it would be overwritten with the latest data
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question