How to retrieve the data from database?

Answers were Sorted based on User's Feedback



How to retrieve the data from database?..

Answer / haribabu

by using data base checkpoint what ever you want to
retrieve the data

Is This Answer Correct ?    5 Yes 0 No

How to retrieve the data from database?..

Answer / srinu

retrieve the data from the data table

Is This Answer Correct ?    1 Yes 0 No

How to retrieve the data from database?..

Answer / kranthi

Hi Hari,

We can Retrieve data from database using datatable or Data
bse checkpoint

Is This Answer Correct ?    1 Yes 1 No

How to retrieve the data from database?..

Answer / shyam.meghansh

Dim Dsn_conn,rs

Set objConnection=Createobject("ADODB.Connection")
Dsn_conn= "DSN=QT_Flight32;DBQ=C:\Program Files\Mercury
Interactive\QuickTest
Professional\samples\flight\app\flight32.mdb;Driver=C:\WINNT
\system32\odbcjt32.dll;DriverId=281;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;"
objConnection.Open(Dsn_conn)
Set rs=CreateObject("ADODB.RecordSet")

Set rs=objconnection.execute(" select flight_Number from
Flights where flight_Number>20330")

rs.MoveFirst

While Not rs.EOF
Msgbox rs.fields.item("flight_Number")
rs.movenext
Wend


.................Any more question mail me
testingwithshyam@gmail.com

Is This Answer Correct ?    1 Yes 1 No

How to retrieve the data from database?..

Answer / asn

dim con,cmd
set con=createobject("adodb.connection")
set com=createobject("adodb.command")
con.open"provider=sqloledb.1 or ora
oledb.1;server=servername;uid=uid;pwd=password;database=data
sourcename"
cmd.activeconnection
cmd.execute"select*from tablename"

Is This Answer Correct ?    1 Yes 1 No

How to retrieve the data from database?..

Answer / narendra babu

place ur course in data table.
right click on it.select option import data from data base

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More QTP Interview Questions

Ex : some mail name with surname Email id's there that is string fetch the particular surname only how to get particular surname all emails

1 Answers   Infosys,


If enter into interviewer room? how u introduce with him. with shakehand or waht?

2 Answers  


hi is there any chance to change encoding the password

3 Answers  


What is the use of ordinal identifier in qtp?

0 Answers  


where do you store the test result?

2 Answers   HCL,






How we can add actions in the test using QTP?

2 Answers  


I have 5 no.of Action in my Test. Out off which i should make 3rd action as my start-up action. How should i make it?

9 Answers   IBM,


i have string "I LIKE INDIA"..how to i get LIKE from the sting..

6 Answers   HealthAsyst,


1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.

0 Answers  


What is Terminal Emulators”? Why we used in QTP.? How he works on QTP.

1 Answers  


from where we will retrieve data for data driven tests in qtp?

3 Answers  


hi i have one issue while selecting weblist i want show one particalur item in weblist .ex one weblist they are monday to sunday i want show the reporter like thurday in particular weblist can you help me about this thanks balaji

5 Answers  


Categories