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 do you mean by iteration?
How to write business scripts using object repository with different scenarios
Functions call by reference and call by value. i want the diff b/n these 2 and how will be the script for this?in which situation we use these 2..?pls explain me clearly
What are the advantages of qtp?
what is the difference between development and testing
I opened gmail login into gmail and i have to save (Pass or move) all the mail into notepad please give me code Thanks of all
What r the different filters in defect in quality center
How do you configure QTP AND Test director?
Without using gui map editor we can recognize the application in winrunner ?
hou can we use vb script in qtp could u tell me breafly
Which recording modes need more memory?
assume i have few url link how will i dynamically call then using descriptive programming?
Who uses qtp tool?
if anyone has idea of the interview procedure in covansys, plz send me a mail?
Define Environment Variable in UFT and its uses?