Na ovaj nacin pristupam bazi ("Tabela"):
Private Sub Form_Load()
Adodc1.RecordSource = "Tabela"
Set MSFlexGrid1.DataSource = Adodc1
End Sub
Ovako cuvam promene samo u prvom redu FlexGrida, a treba mi da sacuvam promene u celom FlexGridu(10 kolona i 20 redova):
Private Sub ZapamtiPromene()
i = 1
Adodc1.Recordset("Kolona1") = MSFlexGrid1.TextMatrix(i, 1)
Adodc1.Recordset("Kolona2") = MSFlexGrid1.TextMatrix(i, 2)
Adodc1.Recordset("Kolona3") = MSFlexGrid1.TextMatrix(i, 3)
End Sub
Private Sub cmdSave_Click()
Call ZapamtiPromene
Adodc1.Recordset.Update
End Sub
|