msflexgrid in vb 6.0

[sreedivya]

im new to vb 6.0

As im using MSflexgrid in my project

i dont know how to save and edit the grid values into database

please anyone help me out

[debasisdas]

How the grid control is getting populated ?

[sreedivya]

How the grid control is getting populated ?

grid is populated as
i have inserted a combobox in grid and seleted the values from combobox

[QVeen72]

Hi,

Open an ADO connection to your Database,
Open a Recordset, Loop through the Grid rows/ column, and add records..

Some thing like this :

[code=vb]
Dim Conn As New ADODB.Connectio n
Dim RS As New ADODB.Recordset
Dim i As Integer
'
'Open Connection here
RS.Open "Select * From MyTable",Conn, adOpenDynamic, adOpenLockOptim istic
For i = 1 To Grd.Rows-1
RS.AddNew
RS("Fld1") = Grd.TextMatrix( i,0)
RS("Fld2") = Grd.TextMatrix( i,1)
RS("Fld3") = Grd.TextMatrix( i,2)
RS("Fld4") = Grd.TextMatrix( i,3)
RS.Update
Next
[/code]

Or else, use DATAGRID


Regards
Veena

[larix]

im new to vb 6.0

As im using MSflexgrid in my project

i dont know how to save and edit the grid values into database

please anyone help me out

Hi Vidhya,
Just view the opensource of Editable Flexgrid from wbcsoftwarelab, which I use. Hope your doubts are cleared.