02-17-2009, 06:41 AM
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
'******** Both code below worked for adding value in run time data sheet.
'datatable.Value("city",3)="Bombay" '3 is for sheet index for Sheet name My
Datatable.Getsheet("My").GetParameter("city").Value="Bombay"
Data=datatable("city",3)'getting current row value from sheet My index 3
msgbox Data