How to show request plan in gridview asp.net

Question

how to show query plan from SQL Server 2008 on gridview asp.net

my sql server 2008 code

SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(qt.TEXT)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2)+1),
qs.execution_count,
qs.total_logical_reads, qs.last_logical_reads,
qs.total_logical_writes, qs.last_logical_writes,
qs.total_worker_time,
qs.last_worker_time,
qs.total_elapsed_time/1000000 total_elapsed_time_in_S,
qs.last_elapsed_time/1000000 last_elapsed_time_in_S,
qs.last_execution_time,
qp.query_plan
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
ORDER BY qs.total_logical_reads DESC 

I need to display the output in gridview

error this

gridview query_plan column does not display data ...

<asp:TemplateField HeaderText="Query Plan" >
    <ItemTemplate>
          <asp:Label ID="lblPlan" Text='<%#Eval("query_plan") %>' runat="server" />
    </ItemTemplate>
</asp:TemplateField>

where did i make a mistake?

Answer 1

Column query_planis XML.

You need to encode HTML code.

ASP.NET 4+ (note the colon after #)

<asp:TemplateField HeaderText="Query Plan">
    <ItemTemplate>
        <asp:Label ID="lblPlan2" Text='<%#: Eval("query_plan") %>' runat="server" />
    </ItemTemplate>
</asp:TemplateField>

Previous Versions

<asp:TemplateField HeaderText="Query Plan">
    <ItemTemplate>
        <asp:Label ID="lblPlan" Text='<%# System.Web.HttpUtility.HtmlEncode(Eval("query_plan").ToString())%>' runat="server" />
    </ItemTemplate>
</asp:TemplateField>