05-01-2013, 08:30 AM
Hi,
Please refer to the sample code to add data to a sheet and modify your code accordingly.
Clue: Please see the usage of AddParameter and GetParameter methods
Regards,
Ravi
Please refer to the sample code to add data to a sheet and modify your code accordingly.
Clue: Please see the usage of AddParameter and GetParameter methods
Code:
DataTable.AddSheet("TempStatusHold")
DataTable.GetSheet("TempStatusHold").AddParameter "A","A"
DataTable.GetSheet("TempStatusHold").AddParameter"B","B"
DataTable.GetSheet("TempStatusHold").AddParameter "C","C"
DataTable.GetSheet("TempStatusHold").AddParameter"D","D"
For i=0 to 16
DataTable.SetCurrentRow(i)
DataTable.GetSheet("TempStatusHold").GetParameter("A").Value=i
DataTable.GetSheet("TempStatusHold").GetParameter("B").Value=i
DataTable.GetSheet("TempStatusHold").GetParameter("C").Value=i
DataTable.GetSheet("TempStatusHold").GetParameter("D").Value=i
Next
Regards,
Ravi