本文介绍了查询以获取列表视图中的列名的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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>)
我们必须访问标头名称
We have to access header names
推荐答案
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'xxx' ORDER BY ORDINAL_POSITION
这篇关于查询以获取列表视图中的列名的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!