| || |
How to import values from database to datatable
I have started using QTP a week back for automating the regression test cases. I got stuck in the below requirement. Please help me.
My requirement is:
Verify the values listed in the table with the values in the database.
Solution I thought:
Connect to database, query database, write results to data table/excel. Read results from data table/excel and compare with the values displayed in the table.
Please let me know how to import the database query results into excel sheet/data table. (Note: database results and table values are dynamic). Each and every time it needs to overwrite the existing values.
Please also let me know the solution I have thought is the correct one or not. If not, suggest the way of doing it in other way.
Thanks & Regards,
Re: How to import values from database to datatable
Dig the forum and there many solutions.