please, I want a sql query that will return the no of fields in a database as an integer
example
i have table student
columns are
regno
surname
othername
I want my result to be 3
what do i do??
omotoyosi
-3
Light Poster
Recommended Answers
Jump to PostHi
Try the query like this
SELECT count(*) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'mytable'
All 4 Replies
vizy
0
Light Poster
Hi
Try the query like this
SELECT count(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'mytable'
omotoyosi
-3
Light Poster
How will I attach the result to the label
mIssy_ricco
-3
Light Poster
do u want to display the no or what?
kvprajapati
1,826
Posting Genius
Team Colleague
You may use FieldCount property of DataReader or Count property of DataTable's columns collection.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.