How to write Query to Display Column Names of HTML table in ListView <HTML DIR=LTR> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252"> <TITLE>DailyReport</TITLE> </HEAD> <BODY> <TABLE DIR=LTR BORDER> <CAPTION>DailyReport</CAPTION> <TR> <TH>SLNo</TH> <TH>Day</TH> <TH>Date</TH> <TH>Task</TH> <TH>TaskPurpose</TH> <TH>TimeTakeninMinutes</TH> <TH>TaskDeliverable</TH> <TH>Purpose</TH> </TR> </TABLE> </BODY> </HTML> as of now i am displaying (Select * from HTML_Table) in Datagridview but don't know how to get header name (<tr>)
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'xxx' ORDER BY ORDINAL_POSITION
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)