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_Click()
With Me.VSFlexGrid1
For i = 1 To 5
For j = 1 To 4
.Row = i
.Col = j
.Cell(flexcpText, 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.TextMatrix(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.TextMatrix(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?

[Shailja]

've u tryed the code?

I am able to enter data by setting its Editable property. Now listen my problem carefully.

I have kept only one row in grid at runtime. Now after entering one record, i want new row to be added dynamically so i can enter more data. How to do that? Plz let me know.

[vijaydiwakar]

I am able to enter data by setting its Editable property. Now listen my problem carefully.

I have kept only one row in grid at runtime. Now after entering one record, i want new row to be added dynamically so i can enter more data. How to do that? Plz let me know.

Now listen carefully
use flex.rows=flex.rows+1
for that