Interested to Buy Any Domain ? << Click Here >> for more details...
write a VBscript code to parametrize test script using test
data from sqlserver database?
- 2 Answers
- 15940 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rajh
dim con,rec
set con=create object("adodb.connection")
set rec=create object("adodb.recordset")
con.open"provider=sqloledb.1;server=name;username=scott;pwd=tiger;database=dbname'
rec.open"sql statement"con
while not rec.eof
window("winmame").winedit("uname").set rs.fields(un)
in the same way use the data
loop
| Is This Answer Correct ? | 6 Yes | 0 No |
can u write Script to do Data Driven Testing throuh Externel & internel XL Sheet
How to handle Dynamically changing Objects in QTP?
How qtp recognizes the object?
Explain Different types of Checkpoints in Quick Test Professional?
How can i use Ordinal identifiers and Smart identification methods suppose i want to know the index no of check box
in flight reservation application. when i entered flyto combobox as london. and i have to check this london is present in flyfrom combobox.give me the code with good explanation. extention to this question. at each iteration i have to put(WRITE) the fly from and fly to city in database table
How will you report the bug and explain the defect tracking sheet you handled?
What is a programmatic description?
how will we run batch tests in qtp what is the process to run the multiple test sets?
what is the difference btn risks & Therads in the Test plan documentation?
How to retrieve particular cell data in excel sheet ?without importing method.
How to Identify broken links in QTP
WinRunner 
