Trying to bind results from stored procedure to Line chart

170

Tom Murray posted over 4 years ago

I am calling a stored procedure where I pass variable for number of days to report on.

            With cmd
                .Connection = sqlcon
                .CommandType = CommandType.StoredProcedure
                .Parameters.Clear()
                .CommandText = "dbo.GetAverageResolvedTimeforDashBoard"
                .Parameters.AddWithValue("@Days", dy)
                .Parameters.Add("@Recs", SqlDbType.Int).Value = DBNull.Value
                .Parameters("@Recs").Direction = ParameterDirection.Output

End With

I then define a DataTable and fill it using a DataAdapter.

Dim datTab As New DataTable

Try
Using myadp As SqlDataAdapter = New SqlDataAdapter(cmd)

                    myadp.Fill(datTab)
                End Using
                ugResolved.Data.SwapRowsAndColumns = True
                ugResolved.DataSource = datTab

ugResolved.DataBind()

            Catch ex As Exception
                MsgBox(ex.Message)
            End Try

When I run the Stroed Procedure in Management Studios I get the results I expect

When I run from IDE in Visual Studio 2017, code is Vb, I get a white box saying Data Not Available. Please call UltraChart.Data>dateBind() after setting valid Data.DataSource.

I have put break point in and printed out all the values for DataTable (DatTab) and all the data is there. My question is why won't it Bind What am I missing.

Parents

28945

Offline Michael DiFilippo posted over 4 years ago

Hello Tom,

Thank you for contacting Infragistics. Please have a look at the sample attached below. Binding to the DataTable is all you really need. It's possible this is just a timing issue. Try and incorporate the dummy data from my sample into your application and see if it works.

UltraChartLineChart.zip
Cancel
Reply

Cancel
170

Offline Tom Murray posted over 4 years ago in reply to Michael DiFilippo

Does the number of columns have impact. My stored procedure may have up to 8 columns. first being Date and the remaining columns depends on how many users worked on things during those days. A row in dataTable may be

"11/11/2019", "33.5","25.7", "68","42"

And the columns headers would be "Date", "Bill","Jack",'Sally","Sam"

and the row count would be whatever the variable to passed to Sproc (number of days)

What does a timing thing mean. That the chart is being displayed before data is returned?
Cancel
Reply

Cancel
28945

Offline Michael DiFilippo posted over 4 years ago in reply to Tom Murray

I don't think a remote meeting is going to help in resolving the issue. Please modify the sample or provide a new one to replicate the issue and send it back. Thank you.

You can refer to our online documentation for more details:

https://www.infragistics.com/help/winforms/chart-adding-chart-to-a-form
Cancel
Reply

Cancel
170

Offline Tom Murray posted over 4 years ago in reply to Michael DiFilippo

Michael, This here little bit of code is not working. I have simplified everything and still get same result of call databind after setting datasource.

Imports Infragistics.Win.UltraWinChart

Public Class Form1
    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        InitializeComponent()
        Dim dt As DataTable = New DataTable
        dt.Columns.Add("Date", GetType(String)) '---- have also tried with Date here in place of string
        dt.Columns.Add("Erin", GetType(Int64))
        dt.Columns.Add("Mike", GetType(Int64))
        dt.Columns.Add("Paul A", GetType(Int64))
        dt.Columns.Add("Tom", GetType(Int64))

        dt.Rows.Add("11/8/2019", 55, 0, 0, 134)
        dt.Rows.Add("11/11/2019", 132, 118, 34, 0)
        ' End Using
        UltraChart1.Data.DataSource = dt
        UltraChart1.Data.DataBind()
    End Sub
End Class
Cancel
Reply

Cancel
28945

Offline Michael DiFilippo posted over 4 years ago in reply to Tom Murray

Hello Tom,

What doesn't work? I used your code in my original sample and got two lines, hence from the two rows you added. Please see attached. If you swap rows with columns you should see four lines for each name.

UltraChartLineChart (2).zip
Cancel
Reply

Cancel
170

Offline Tom Murray posted over 4 years ago in reply to Michael DiFilippo

Just giving you a thank you for your time. I found the issue is line

InitializeComponent()

Good for C# but caused VB.net not to be able to display chart
Cancel
Reply

Cancel

Reply

28945

Offline Michael DiFilippo posted over 4 years ago in reply to Tom Murray

Your welcome, yes InitializeComponent() is not applicable in a VB app.
Cancel
Reply

Cancel

Children

No Data