Does anyone have the answer to these 2 questions?

[piscis]

Gentlemen:

Does anyone have the answer to these 2 questions?

1. How to sum only those records for the month of March in column 4 in datagrid1 and display it in a textbox3 located in a Tab Control #2 named “Ventas”
2. How to sum ALL records in column 4 in datagrid1 and display it in textbox8 located in a Tab Control #2 named “Ventas”

Thanks

Andy

[Redth]

first things first... please try and post topics with more descriptive subject lines. Something like "Displaying Records in Datagrid" It's so much nicer to be able to tell what your question is about by glancing at the topic... and, it kind of gets some people frustrated and that will make them less likely to answer your questions.

and for your actual questions:

we need lots more information. like your database table structure, etc etc... you must provide enough information, otherwise nobody can help you...

[piscis]

Redth:



You are right about this, I will write some code and repost, thanks.

Andy

[piscis]

Redth:

Do you know why I'm getting this error?

On this line:

If IsNumeric(Me.Item(row, col)) Then

Error: Item is not a member of Project.frmMain'

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

        Dim ds As DataSet = Me.DsBrio250Table5
        'where "Me" is the datagrid
        Dim rowCount As Integer = ds.Tables(0).Rows.Count()
        Dim col As Integer = 4
        Dim row As Integer
        Dim dsum As Double

        For row = 0 To rowCount - 1
            If IsNumeric(Me.Item(row, col)) Then
                dsum = dsum + CLng(IIf(IsDBNull(Me.Item(row, col)), "0", Me.Item(row, col)))
            End If
        Next row
    End Sub

[Pirate]

Maybe you mean this one (for the first error)

If IsNumeric(Me.DataGrid1.Item.Item(row, col)) Then

[Pirate]

And btw , Me is reserved keyword . It represent the current instance of the form . Change it to something else .