Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the column headers in database using
vbscript statement in QTP
- 1 Answers
- 14968 Views
- I also Faced
- E-Mail Answers
VB Script Code to retrieve all column names
var_ConnectionString = "" 'specify the connection string
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open var_ConnectionString
Set objRecordSet = CreateObject("ADODB.RecordSet")
strSqlQuery = "select * from employee"
'Execute query and Store the results into Record set
objRecordSet.Open strSqlQuery, objConnection
For var_Loop = 0 To objRecordSet.Fields.Count - 1
colname = objRecordSet.Fields(var_Loop).Name 'column name
msgbox colname
Next
| Is This Answer Correct ? | 8 Yes | 3 No |
how can we retrieve ten rows from the data table using loop concept?
what is batch testing?
what is retesting?
what is test scheduling?
what is profile tool?
How can we automate Capthca on registration or any contest forms ? Is it possile to Automate Webpages with Falsh using QTP..?
It seems Interview questions from Ordain Solutions are almost BASIC LEVEL-Easy. I am asking one tough question..(I think.. May be easy for some people) In recorded script the - WebLink("cityinfo") In reality, the WebLink name is "generalinfo" How you can write function to click that changed web link. NOTE: This functin should work with any Dynamic text link. I will post the answer later.
How can i Save the snapshots in a specified folders using Scripting in QTP?
How does quicktest professional (qtp) identifies the object in the application?
How to create an instance in QTP?
What is the Major difference between QTP ; LoadRunner? If u want to test an 1. erp module which automation tool you would prefer and why? and 2. for web application, which tool and why?
How do you send email with attachment from outlook using qtp ?
WinRunner 
