write a VBscript code to parametrize test script using test
data from sqlserver database?
Answer Posted / kamesh n
first connect to database using the following script
set sqlconnection=createobject("ADODB.connection")
set sqlrecordset=createobject("ADODB.recordset")
To open the connection
sqlconnection.open "You have to mention your database
connection string"
sqlrecordset.open "Give your query",sqlconnection
to run through all the records
if not sqlrecordset.EOF then
suppose your are going to set it to a textbox then
Browser(browsername).page(pagetitle).webedit
(testboxname).set sqlrecordset(columnname)
end if
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
what type of values given to objects. EX::Set oBrowser=Description.Create oBrowser(“micclass”).Value=”Browser”
Which functionalities of QTP used in banking project?
Hi, can explain the draw back of manual testing.plz send me the answer to my mail id deepthip1985@gmail.com
wt is the use of multiple questions in QTP
What is qtpro? What is quick test pro?
How to Upgrade or support firefox 2.0 version on QTP 9.0? I have installed QTP 9.0 and installed firefox 2.0. But in REcord and Run Settings, it shows firefox 1.5 in Web tab for browser selection.
What is the file extension of the code file and object repository file in QTP?
How you can decide which type of object repository you have to use?
What is method name to compare two XML files.
how do u manipulating INI, DLL and / or registry files in support of your test environment? actually what do u mean by INI and DLL or registry files. plzzz its urgent do answer
What is an expert view and keyword view?
How did you resolve conflicts present in Object Repository?
What is expert view in qtp?
hi i am working with vbwindow on qtp.first i am openning qtp whenever open qtp my application not open that time generated error like "Runtime error 0" and fatal error:automation error how to solve this problem pls tell me
How to integrate the qualitycenter with qtp