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 !