How to enter data into VSFlexGrid at runtime

[Shailja]

Hi,

Can anyone tell me how to enter data into VSFlexGrid at runtime? Kindly send me coding of that.

[iburyak]

http://www.tek-tips.com/viewthread.c...1232027&page=6

[iburyak]

The following code will fill the first 5 rows × 4 columns block of cells with numbers from 1 through 20.


[PHP]Private Sub VSFlexGrid1_Cli ck()
With Me.VSFlexGrid1
For i = 1 To 5
For j = 1 To 4
.Row = i
.Col = j
.Cell(flexcpTex t, i, j) = (i - 1) * 4 + j
Next j
Next i
End With
End Sub[/PHP]

[pureenhanoi]

Hi,

Can anyone tell me how to enter data into VSFlexGrid at runtime? Kindly send me coding of that.

I don't know which version of VSFlexGrid you have. But i usually use VSFlexGrid Pro 7.0.
To enter data into VSFlexGrid, you should set EditAble property to 1-flexEDKbd or 2-flexEDKbdMouse.
If that property = 2, you can click mouse on cell, and then enter data.
To enter data by code, you can use TextMatrix(row, col) method
example: VSFlexGrid1.Tex tMatrix(1,1) = "your data". Remember add at least one row and one col to enable enter data

[Shailja]

I don't know which version of VSFlexGrid you have. But i usually use VSFlexGrid Pro 7.0.
To enter data into VSFlexGrid, you should set EditAble property to 1-flexEDKbd or 2-flexEDKbdMouse.
If that property = 2, you can click mouse on cell, and then enter data.
To enter data by code, you can use TextMatrix(row, col) method
example: VSFlexGrid1.Tex tMatrix(1,1) = "your data". Remember add at least one row and one col to enable enter data

Thanks. Now I am able to enter data in VSFlexGrid. After entering data into Grid, I want to save entered data into table. How to do coding of that? Kindly send me coding

[vijaydiwakar]

Thanks. Now I am able to enter data in VSFlexGrid. After entering data into Grid, I want to save entered data into table. How to do coding of that? Kindly send me coding

drive to loops one for row and another for col
adjust the qry
and execute it

[pureenhanoi]

Thanks. Now I am able to enter data in VSFlexGrid. After entering data into Grid, I want to save entered data into table. How to do coding of that? Kindly send me coding

what kind of table will you save your data.

[vijaydiwakar]

 
conn.begintrans
with Flex
for i=.fixedrows to .rows-1
ssql="Insert into <tblname> (<filed1>,<Filed2>) values (
for j=.fixedcols to .cols-1
ssql=ssql & .textmatrix(i,j) & "" 
if j<>.cols-1 then ssql=ssql & " , "  
next
ssql=ssql & " )"
conn.execute ssql
next
end with
conn.committrans
 

like it
Try it
Good Luck

[Killer42]

Just a note to let you know, I've changed the title of the thread to something more appropriate than "help me soon".

MODERATOR

[vijaydiwakar]

've u tryed the code?