How to append values to the existing datatable in qtp during runtime

[Prashanth]

Hi,

I have a problem,
I create a datasheet during runtime and add a web table value which contain header and data during runtime,

now i want to add the next set of values/data(header not needed) to the same datatable retaining the previous header/column names and data along with the new data..

Code am using

Code:

With Browser(---).page(---)
            clcnt=.WebTable("class:=dataGrid").ColumnCount(1)                        
    datatable.AddSheet("TempStatusHold")
    For i=1 to clcnt                    
    columnHeader=.WebTable("class:=dataGrid").GetCellData(1,i)                        
    columnVal=.WebTable("class:=dataGrid").GetCellData(3,i)                        
    datatable.GetSheet("TempStatusHold").AddParameter columnHeader,columnVal                        
    Next
    
      datatable.GetSheet("TempStatusHold").SetNextRow
     (or) datatable.GetSheet("TempStatusHold").SetCurrentRow(3)

     For i=1 to clcnt                                    
     columnVal=.WebTable("class:=dataGrid").GetCellData(3,i)                        
     datatable.GetSheet("TempStatusHold").AddParameter " ",columnVal                        
       Next

End With

====================================================
With the above code,,, the new set of data is replacing the the old value

Please suggest ......

[ravi.gajul]

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

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