Member Avatar for omotoyosi

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??

  • 4 Contributors
  • 4 Replies
  • 83 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for vizy

Hi

Try the query like this

SELECT count(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'mytable'
Member Avatar for omotoyosi

How will I attach the result to the label

Member Avatar for mIssy_ricco

do u want to display the no or what?

Member Avatar for kvprajapati

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.