Save data from grid in a database table

[vagaisuresh]

Friends,

Five rows available in a grid. I want to save these rows in a database in five records. Make this saving with single click (command button). Anybody help me.

Thanks!
Suresh

[vagaisuresh]

dear friends

anybody help me?

suresh

[maaaryam]

dear friends

anybody help me?

suresh

hi suresh,
chk this...
define Connection string Name
define Recordset Name
on command button clik event
set connection string
open a record set to a database Table
recordsetName.addnew (Mode)

recordsetName.field(1)=msflexgrid.textmatrix(rowNo ,ColNo)
recordsetName.field(2)=msflexgrid.textmatrix(rowNo ,ColNo)
recordset.updateBatch
upto 5 records

[vagaisuresh]

hi suresh,
chk this...
define Connection string Name
define Recordset Name
on command button clik event
set connection string
open a record set to a database Table
recordsetName.addnew (Mode)

recordsetName.field(1)=msflexgrid.textmatrix(rowNo ,ColNo)
recordsetName.field(2)=msflexgrid.textmatrix(rowNo ,ColNo)
recordset.updateBatch
upto 5 records

Friend,

Thanks for the same. Can you please give me a example code?

Thanks!
Suresh

[shaileshb]

hi

pls chk this

dim rs as new adodb.recordset
dim mRow as integer
rs.open "Select * From Categories", con, adOpenDynamic, adLockOptimistic

'suppose u r using MSHFlexGrid1 Grid Control having 4 columns

With MSHFlexGrid1
For mRow = 1 To .Rows - 1
rs.AddNew
Rs.Fields(0).Value = .TextMatrix(mRow,0)
Rs.Fields(1).Value = .TextMatrix(mRow,1)
Rs.Fields(2).Value = .TextMatrix(mRow,2)
Rs.Fields(3).Value = .TextMatrix(mRow,3)
rs.Update
Next mRow
End With

set rs = nothing