如何以HTML格式显示数据集数据 [英] How to display dataset data in HTML Format

问题描述

我有一个数据集，我需要在.cs页面（代码隐藏）中的HTML表格中显示这些数据。请找到我如何实现这个&浏览我的代码

 sb.AppendLine（ < html>< body>< center>< + 
 
   table border ='1'cellpadding ='0'cellspacing ='0'>）; 
 
 sb.AppendLine（ < tr>）; 
 
 sb.AppendLine（ < td>< b> ）; 
 
 sb.Append（  Kundali Details）; 
 
 sb.Append（ < / b>< / td>）; 
 
 sb.AppendLine（ < / tr>）; 
 
 sb.AppendLine（ < tr>）; 
 
 sb.Append（ < td>）Server.HtmlDecode （dt.Rows [ 0 ] [  Aries].ToString(); //  我在这一行收到错误 
 
 sb.Append（ < / td）; 
 
 sb.Append（ < td>）Server.HtmlDecode（dt.Rows [< span class =code-digit> 0 ] [  Taurus]。ToString （）; 
 
 sb.Append（ < / td） ; 
 
 sb.Append（ < td> Gemini）; 
 
 sb.Append（  < / td）; 
 
 sb.Append（ < td> Cancer）; 
 
 sb.Append（ < / td）; 
 
 sb.AppendLine（ < / tr>）; 

解决方案

1。你使用datalist：喜欢这个



< asp：DataList ID =DataList2runat =serverRepeatColumns =6Width =400px>

< ItemTemplate>

< table>

< tr>< td>

< asp ：Label ID =Label3runat =serverText =''<％＃Eval（text）％>''>< / asp：Label>

< / td>< / tr>

< / table>

< / itemtemplate>

< pre lang =text >< /预>





，在代码页中绑定它：

ds表示数据集：







DataList2.DataSource = ds;

DataList2.DataBind（）;

您好找到以下代码，我需要以HTML表格格式而不是字段值1显示数据集的内容我需要显示数据集值。请找到答案

私有字符串TableToHtml（System.Web.UI.HtmlControls.HtmlTable tbl）
 {
 dt = s.gethoroscopeacctouser（CustId ）; 
 StringBuilder sb = new StringBuilder（）; 
 StringWriter sw = new StringWriter（sb）; 
 HtmlTextWriter hw = new HtmlTextWriter（sw）; 
 tbl.RenderControl（hw）; 
 sb.AppendLine（<   html   >  <   body  >  <   center  >  <      +   
   
                                                table     cellspacing   ='  0'    width   ='  500％'    border  < span class =code-keyword> ='  1'    title   ='  Kundali详细信息' > ）; 
 sb.AppendLine（<   tr   > ）; 
 sb.AppendLine（<   td     colspan   =   2  < span class =code-attribute> align   =   center   valign   =   middle  > ;  <   b  > ）; 
 sb.Append（Kundali详情）; 
 sb.Append（<   / b  >  <   / td  > ; ）; 
 sb.AppendLine（<   / tr  > ）; 
 sb.AppendLine（<   tr   > ）; 
 sb.Append（<   td   > ）; 
 sb.Append（<   input     id   ='  Text12'    type   ='  text'    value   ='  12' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text1'    type   ='  text'    value   ='  1' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text2'    type   ='  text'    value   ='  2' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text3'    type   ='  text'    value   ='  3' > ）; 
 sb.Append（<   / td）;   
   
                 sb.AppendLine（< / tr  > ）; 
 
 sb.AppendLine（<   tr  > ）; 
 sb.Append（<   td   > ）; 
 sb.Append（<   input     id   ='  Text11'    type   ='  text'    value   ='  11' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text1'    type   ='  text' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text1'    type   ='  text' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text4'    type   ='  text' > ）; 
 sb.Append（<   / td）;   
   
                 sb.AppendLine（< / tr  > ）; 
 
 sb.AppendLine（<   tr  > ）; 
 sb.Append（<   td   > ）; 
 sb.Append（<   input     id   ='  Text10'    type   ='  text'    value   ='  10' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text1'    type   ='  text' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text1'    type   ='  text' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text5'    type   ='  text'    value   ='  5' > ）; 
 sb.Append（<   / td）;   
   
                 sb.AppendLine（< / tr  > ）; 
 
 sb.AppendLine（<   tr  > ）; 
 sb.Append（<   td   > ）; 
 sb.Append（<   input     id   ='  Text9'    type   ='  text'    value   ='  9' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text8'    type   ='  text'    value   ='  8' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text7'    type   ='  text'    value   ='  7' > ）; 
 sb.Append（<   / td）;   
   
                 sb.Append（< td  > ）; 
 sb.Append（<   input     id   ='  Text6'    type   ='  text'    value   ='  6' > ）; 
 sb.Append（<   / td）;   
   
                 sb.AppendLine（< / tr  > ）; 
 sb.AppendLine（<   / table  >  <   / center  > ;  <   / body  >  <   / html  > ）; 
返回sb.ToString（）; 
} 

Hi,
I have an dataset i need to display those data inside an HTML table in .cs page(Code behind).Please find me how to achieve this & go through my code

sb.AppendLine("<html><body><center><" +

                        "table border='1' cellpadding='0' cellspacing='0'>");

        sb.AppendLine("<tr>");

        sb.AppendLine("<td><b>");

        sb.Append("Kundali Details");

        sb.Append("</b></td>");

        sb.AppendLine("</tr>");

        sb.AppendLine("<tr>");

        sb.Append("<td>")Server.HtmlDecode(dt.Rows[0]["Aries"].ToString();//I am getting error in this line

        sb.Append("</td");

        sb.Append("<td>")Server.HtmlDecode(dt.Rows[0]["Taurus"].ToString();

        sb.Append("</td");

        sb.Append("<td>Gemini");

        sb.Append("</td");

        sb.Append("<td>Cancer");

        sb.Append("</td");

        sb.AppendLine("</tr>");

解决方案

1. you use datalist: like this

<asp:DataList ID="DataList2" runat="server" RepeatColumns="6" Width="400px" >
<ItemTemplate>
<table>
<tr><td>
<asp:Label ID="Label3" runat="server" Text=''<%#Eval("text") %>''></asp:Label>
</td></tr>
</table>
</itemtemplate>
<pre lang="text"></pre>


and, in code page bind it:
ds means data set:



DataList2.DataSource = ds;
DataList2.DataBind();

Hi find this below code and i need to display the content of dataset in the HTML table format instead of field value 1 i need to display the dataset values.pls find me the answer

private string TableToHtml(System.Web.UI.HtmlControls.HtmlTable tbl)
   {
       dt = s.gethoroscopeacctouser(CustId);
       StringBuilder sb = new StringBuilder();
       StringWriter sw = new StringWriter(sb);
       HtmlTextWriter hw = new HtmlTextWriter(sw);
       tbl.RenderControl(hw);
       sb.AppendLine("<html><body><center><" +

                       "table cellspacing='0' width='500%' border='1' title='Kundali Details'>");
       sb.AppendLine("<tr>");
       sb.AppendLine("<td colspan=2 align=center valign=middle><b>");
       sb.Append("Kundali Details");
       sb.Append("</b></td>");
       sb.AppendLine("</tr>");
       sb.AppendLine("<tr>");
       sb.Append("<td>");
       sb.Append("<input id='Text12' type='text' value='12'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text1' type='text' value='1'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text2' type='text' value='2'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text3' type='text' value='3'>");
       sb.Append("</td");

       sb.AppendLine("</tr>");

       sb.AppendLine("<tr>");
       sb.Append("<td>");
       sb.Append("<input id='Text11' type='text' value='11'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text1' type='text'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text1' type='text'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text4' type='text'>");
       sb.Append("</td");

       sb.AppendLine("</tr>");

       sb.AppendLine("<tr>");
       sb.Append("<td>");
       sb.Append("<input id='Text10' type='text' value='10'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text1' type='text'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text1' type='text'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text5' type='text' value='5'>");
       sb.Append("</td");

       sb.AppendLine("</tr>");

       sb.AppendLine("<tr>");
       sb.Append("<td>");
       sb.Append("<input id='Text9' type='text' value='9'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text8' type='text' value='8'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text7' type='text' value='7'>");
       sb.Append("</td");

       sb.Append("<td>");
       sb.Append("<input id='Text6' type='text' value='6'>");
       sb.Append("</td");

       sb.AppendLine("</tr>");
       sb.AppendLine("</table></center></body></html>");
       return sb.ToString();
   }

这篇关于如何以HTML格式显示数据集数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！