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

i want click on a link which is in 3rd row and 2nd column of a web table.write script to execute

2 Answers   IBM,


What is the vb script when the url enter into the browser

2 Answers   Satyam,


in my application,validation message has in japanise language.how to validate this message is appears properly or not

1 Answers  


Write a script to verify font style and color of a windows object using descriptive programming

1 Answers  


What is the difference between Dim And Redim

4 Answers   Hotel Jobs, IBM, Microsoft,


Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya

1 Answers  


How can we disable popup blocker? (I think it means when we get a pop up messge(its error) how we wil disable that one with out interrupting normal process)

6 Answers  


What is the use of text output value in quicktest professional?

1 Answers  


how to retrieve the xml file data through qtp. can anybody send script for this..

3 Answers   Synechron,


what is the diffrence between script and Language ? (Chandana)

6 Answers   Cognizant, Wipro,


How to Compare two database tables by using QTP?Please give me code details.

1 Answers  


What are the enhancements u did after recording ur script?

3 Answers  


Categories