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
Explain in brief about the quicktest professional (qtp) automation object model?
How the exception handling can be done using quicktest professional (qtp)?
Explain how qtp identifies objects?
How to create a standard checkpoint ?
WHAT IS THE DIFFERENCE BETWEEN QTP SCRIPT AND VB SCRIPT? HOW MUCH PERCENTAGE WE USE IN QTP SCRIPT REAL TIME AND HOW MUCH PERCEN OF VB SCRIPT,,,,,,,
What is keyword view?
Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?
Should have experience in framework means?
supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?
Difference between action & Reusable action?
Explain types of descriptive programming?
How to connect to a database?
What is use of object spy?
please any one can explain the keyword driven framework. with gmail example.
In qtp, how you can remove the spaces from string?