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 :

Dim Conn As New ADODB.Connection
Dim RS As New ADODB.Recordset
Dim i As Integer
'
'Open Connection here
RS.Open "Select * From MyTable",Conn, adOpenDynamic, adOpenLockOptimistic
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
 

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.