How to get particular column count in data set using c#?

Question

get column count in sql using c#

Rahul Chavan · Answer

Execute below query throgh .Net Code SELECT COUNT ( COLUMN_NAME ) FROM INFORMATION_SCHEMA . COLUMNS WHERE TABLE_CATALOG = 'database' AND TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'table' -or- Refer below link http://www.c-sharpcorner.com/UploadFile/puranindia/rows-count-column-count-and-ienumerator-using-ado-net-with-C-Sharp-and-database-server/ -Please accept the answer if it working.