[anandrosan1]

Hi all ! I am using vb6 and Datagrid ! I have an access database and i display those records in datagrid ! For example, there is a column named marks ! Below the datagrid there is a button and textbox named total ! if i click the button means, then the marks column in the datagrid should be added and display the result in the textbox ! I have tried the following method but it doesn't work !

Public con As New ADODB.Connection
Public rs As New ADODB.Recordset

In the form load the following code contains !

Set con = New ADODB.Connection
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\college.mdb;Persist Security Info=False"
con.CursorLocation = adUseClient
Set rs = New ADODB.Recordset
rs.open "select marks from student",con,1,3
set Datagrid1.Datasource = rs

The marks column in the access is displaying correctly in the datagrid ! but i don't know how to take the values from the datagrid and add them up and display the total marks in a textbox ! Thanks in advance !

[andrewsw]

You would loop through the underlying recordset:

Dim dblSum As Double
  
rs.MoveFirst
Do While Not rs.EOF
    dblSum = dblSum + rs.Fields(2)    'or .Fields("marks") or .Fields!marks
    rs.MoveNext
Loop
TextBox1.Text = "Total: " & dblSum
  
rs.MoveFirst

BTW I'm unable to test this as I don't have VB6.

This post has been edited by andrewsw: 12 January 2013 - 08:59 PM

[anandrosan1]

It works friend ! thanks !

[maj3091]

Or alternatively, you could use a query similar to what you had...

something like...

Select sum(marks) from student

[anandrosan1]

This problem has been solved ! Here is another problem and take a look here http://goo.gl/fmXvs

[maj3091]

anandrosan1, on 13 January 2013 - 05:17 PM, said:

This problem has been solved ! Here is another problem and take a look here http://goo.gl/fmXvs

Yes, I realised it was solved, I was just giving you an alternative for future.

[anandrosan1]

Yes i know friend thank you so much ! did you take a look into the new link that I've given above and could you give me an idea in that friend?

[BobRodes]

As I mentioned in another post, please stop using exclamation points in your writing until you learn how to use them properly. It's very distracting and makes it hard to understand what you are saying. Thank you!