Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the column count and column name from the
resultset in the database connection program?
- 5 Answers
- 17738 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ram
you use following sql query
select column name, count(column name)from table name.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / tvsrkc
we can get the column count by following code
------------------------------------------------
set colcoll=rs.fields
colcnt=colcoll.count
for i=0 to colcnt-1
msgbox rs.fields(i).name
rs.movenext
next
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / mahesh
select count(column name) column name from the table.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / nageshbijoor@gmail.com
you can get column count using following code
totalrec = 0
DataTable datatable
datatable = ds.Tables["tablename"]
totalrec = datatable.Rows.Count
Label1.Text = datatable.Rows[currrec]["columnname"].ToString
()
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / krishnat.qa
we can get the column count by following code
-----------------------------------------------------
set colcoll=rs.fields
colcnt=colcoll.count
for i=0 to colcnt-1
msgbox rs.fields(i).name
rs.movenext
next
| Is This Answer Correct ? | 1 Yes | 3 No |
Hi, Can anyone tell me what type questions can be ashed in interview on QTP?
1.How recognize QTP Dyanamic Image? (suppose tha wedpage contains 3 logos..1 square 2.circle 3.rectangel)there changing at same position how to capture that)
What is Terminal Emulators”? Why we used in QTP.? How he works on QTP.
How to use Regular Expressions in QTP? give an example.
10 Answers ABC, Accenture, Ordain Solutions, SCL,
what is descriptive.create()in qtp?
Hoe we can export TEST RESUALT IN to XL-sheet?
how to test background color and dynamic images during runtime
How can i use Ordinal identifiers and Smart identification methods suppose i want to know the index no of check box
What is output value?
What is checkpoints for quicktest professional?
how to explain a claims and insurance project?
How to record & run on Japanese language application using english version of QTP ???
WinRunner 
