hello...im new in vb world.so please help me if someone can..my problem in details:
1.have created a ms access database file named Database2.mdb which has 5 columns as follows a,b,c,d and result.it has 5 row and a,b,c,d are filled with data but result column is empty.
2.have created a datagrid in vb6 and connected this database file with datagrid and it is showing well..no problem..
3.now wrote a code in another form as
For rowcount = 1 To Adodc1.Recordset.RecordCount
a = DataGrid1.Columns(1).Text
b = DataGrid1.Columns(2).Text
c = DataGrid1.Columns(3).Text
d = DataGrid1.Columns(4).Text
(here should be some step to update the value of result in each iteration in that datagrid result column..)
problem:could not update the databse with those calculated result...please help someone..