Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What do you mean by iteration?

1206


How to write business scripts using object repository with different scenarios

1917


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

1744


What are the advantages of qtp?

1011


what is the difference between development and testing

3707


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

2098


What r the different filters in defect in quality center

3763


How do you configure QTP AND Test director?

1940


Without using gui map editor we can recognize the application in winrunner ?

1056


hou can we use vb script in qtp could u tell me breafly

2200


Which recording modes need more memory?

1060


assume i have few url link how will i dynamically call then using descriptive programming?

2025


Who uses qtp tool?

990


if anyone has idea of the interview procedure in covansys, plz send me a mail?

1974


Define Environment Variable in UFT and its uses?

1081