Save grid values to database

[Former Member]

Hi All..

how to save grid values in database??

thanks in advance....

[Nussi]

Hi,

1 minute before another one posted a similar questions

so again:

it's up to you to insert the data to DB.

you have to go through the grid (cells) and save the data in DB.

lg David

[Former Member]

Hi,

Please go through this code. I think it will use for your requirement.

Dim objMatDet As SAPbouiCOM.Matrix

Dim rsTrial As Recordset

Dim objForm As SAPbouiCOM.Form

Dim intCount As Integer

dim valBudjet as edittext

dim strBudjet as string

dim strSql as string

objMatDet = objForm.Items.Item("12").Specific

If objMatDet.RowCount > 0 Then

For intCount = 1 To objMatDet.VisualRowCount - 1

valAcctName = objMatDet.Columns.Item("3").Cells.Item(intCount).Specific

If valBudjet.Value "" Then

strBudjet = valBudjet.Value

Else

strBudjet = ""

End If

-

---

>>>>>>> Here u can write a query to insert in the database

Next

end if

Regards,

Benjamin

[Former Member]

Hi,

Check this thread,

Vasu Natari.