Page 1 of 1

Store Different Data

PostPosted: Tue Nov 19, 2019 8:47 am
by npandit
Am using this line to store a value in a cell:
'ocell = oSheet.getCellrangeByname("E1").SetString(txtFlowrateCase1.Text) 'set string
but i have 5 records t and am printing all the records together
It only prints the record which is displayed.(data which is currrently displayed in the textbox)What about the record which i have already stored from the same textbox?
How do i Print them all together?
The data is Different in each record accepted by the same textbox

Re: Store Different Data

PostPosted: Tue Nov 19, 2019 5:02 pm
by FJCC
Do you want to store the five values in E1 or do you want them to be in five separate cells?

Re: Store Different Data

PostPosted: Tue Nov 19, 2019 5:35 pm
by floris v
That doesn't make sense. You are talking about printing and storing as if it's the same thing. I suppose that you want to store the data in Record 1, currently displayed in a text box, in cell E1, the data in Record 2 in cell E2, etc. If so, you have to navigate through your database table, fetching one record at a time, then grabbing the data. Repeat until end of table.