Hi Raj,
Try this code.I've used SetNextRow property but it's not setting cursor to next row then i've used setcurrentrow property.Here is the code ,Can anyone tell me where i'm doing wrong?
Thanks to all for there help.
Try this code.I've used SetNextRow property but it's not setting cursor to next row then i've used setcurrentrow property.Here is the code ,Can anyone tell me where i'm doing wrong?
Code:
p=datatable.AddSheet ("My").AddParameter("city","New York")
i=datatable.GetSheet ("My").getcurrentrow
msgbox i 'This will give 1 as the current row is 1.
q=datatable.GetSheet ("My").SetNextRow 'This one is getting null value.It should show 2
'but nothing
msgbox q
datatable.getsheet("My").Setcurrentrow(2) 'then i've used this cuz i know my current
'row index is 2
datatable.Value("city",3)="bombay"
Thanks to all for there help.