write a VBscript code to parametrize test script using test
data from sqlserver database?
- 2 Answers
- 15018 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
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
How to test fly out menu in qtp?
Could any one tell me "How can i recognize my cursor position using QTP 9.2" Give me a scripts for this
How does qtp identify the object in the application?
Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link
Tell me about qtp?
hi nani my doubt is how does qtp process metrix related to software process.
To which environments does quicktest professional supports?
Can any suggest me what is exposure testing?
You will receive the mail in your outlook from client at night time to go ahead for the execution. Based on the mail you need to trigger the batch run. What is the QTP Code for this?
How to use output values in qtp ?
What is different command used in command Prompt while using QTP?
How to handle Java tree in QTP?
How will we compare the texts in the two word files using QTP writing the script in Descriptive Programming. Thanks
What is recovery scenario in qtp?
How to customize checkpoints with parameters?
