Show data in ASP.NET html table

Question

I am writing an ASP.NET page which reads data from a database and needs to show it in a table. For some reason, I don't want to use the gridView.

How do I show the data in a table on the HTML page?

This is my C# code:

        SqlConnection thisConnection = new SqlConnection(dbConnection);
        SqlCommand thisCommand = thisConnection.CreateCommand();
        thisCommand.CommandText = "SELECT * from Test";
        thisConnection.Open();
        SqlDataReader reader = thisCommand.ExecuteReader();

        while (reader.Read())
        {
            int id = reader.GetInt32(0);
            string Name = reader.GetString(1);
            string Pass = reader.GetString(2);                   
        }

        thisConnection.Close();

This is my ASPX page:

<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/test.master" CodeFile="test.aspx.cs" Inherits="test" %>

<asp:Content ID="BodyContent" runat="server"  ContentPlaceHolderID="ContentPlaceHolder">
    <table width="100%" align="center" cellpadding="2" cellspacing="2" border="0" bgcolor="#EAEAEA" >
        <tr align="left" style="background-color:#004080;color:White;" >
            <td> ID </td>                        
            <td> Name </td>            
            <td>Pass</td>                        
        </tr>

        **<%--Need the while output into here--%>**

    </table>
</asp:Content>

try using this projectpeeker.com/2018/01/17/…

raw_hitt
– raw_hitt

2019-08-30 11:03:13 +00:00
Commented Aug 30, 2019 at 11:03 — raw_hitt
– raw_hitt, Commented Aug 30, 2019 at 11:03

Nigel · Accepted Answer · 2016-08-24 05:21:08Z

15

Basically use the classic ASP\PHP\Spaghetti code approach.

First of all, place your code in one public method that returns a string. The method:

public string getWhileLoopData()
{
        string htmlStr = "";
        SqlConnection thisConnection = new SqlConnection(dbConnection);
        SqlCommand thisCommand = thisConnection.CreateCommand();
        thisCommand.CommandText = "SELECT * from Test";
        thisConnection.Open();
        SqlDataReader reader = thisCommand.ExecuteReader();

        while (reader.Read())
        {
            int id = reader.GetInt32(0);
            string Name = reader.GetString(1);
            string Pass = reader.GetString(2);
            htmlStr +="<tr><td>"+id+"</td><td>"+Name+"</td><td>"+Pass+"</td></tr>"                   
        }

        thisConnection.Close();
        return htmlStr;
}

Then you can use the <%=getWhileLoopData()%> tag in ASP.NET that is equal to <%Response.Write(getWhileData())%>

It should look something like this:

<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/test.master" CodeFile="test.aspx.cs" Inherits="test" %>

<asp:Content ID="BodyContent" runat="server"  ContentPlaceHolderID="ContentPlaceHolder">
    <table width="100%" align="center" cellpadding="2" cellspacing="2" border="0" bgcolor="#EAEAEA" >
        <tr align="left" style="background-color:#004080;color:White;" >
            <td> ID </td>                        
            <td> Name </td>            
            <td>Pass</td>                        
        </tr>

        <%=getWhileLoopData()%>

    </table>
</asp:Content>

There is also the option to use an repeater control and bind the data from your DB to an Item Template of your liking.

edited Aug 24, 2016 at 5:21

Nigel

3954 silver badges13 bronze badges

answered Dec 13, 2012 at 13:09

Mortalus

10.7k12 gold badges74 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

riad Over a year ago

can u pls give the full solution??or any example ? or example link??i can't get you. Thanks. But i need to load the output into page_loader

riad Over a year ago

it's showing error when usingt the <%#getWhileLoopData()%> in html page.

Mortalus Over a year ago

just use <%Response.Write(getWhileLoopData())%> or <%=getWhileLoopData()%>sorry about that ..

riad Over a year ago

sorry for bothering. Both showing error.I am using asp.net 4.0.ViewDataBaseDetail.getWhileLoopData()' is inaccessible due to its protection level

Mortalus Over a year ago

sorry again .. change the access modifier from private to public

Manibhadra · Accepted Answer · 2012-12-13 13:17:59Z

2

I suggest you to use repeater control and create your html table structure in repeater.

<table cellpadding="0" cellspacing="0" width="100%">
<asp:Repeater ID="rpt" runat="server" >
<HeaderTemplate>
<tr class="Header">
<td>
ID
</td>
<td>
Name
</td>
<td>
Pass
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<%# Eval("ID")%>
</td>
<td>
<%# Eval("Name")%>
</td>
<td>
<%# Eval("Pass")%>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>
</table>

bind repeater as same as you bind gridview

thanks

answered Dec 13, 2012 at 13:17

community wiki

Manibhadra

Comments

Kevin Panko · Accepted Answer · 2016-04-06 14:42:52Z

1

If you put the runat="server" attribute on your HTML table, you can actually programmatically access it in your code-behind. It's quite a powerful feature.

It's definitely not the best solution, but it's a very cool feature no one knows about.

edited Apr 6, 2016 at 14:42

Kevin Panko

8,60519 gold badges52 silver badges64 bronze badges

answered Dec 13, 2012 at 13:16

Captain Kenpachi

7,2558 gold badges50 silver badges71 bronze badges

1 Comment

riad Over a year ago

could you please give an example??

Mahdi Tahsildari · Accepted Answer · 2012-12-13 13:26:45Z

0

add 3 literal controls to your asp page put them in the tr below the title tds, and then:

while (reader.Read())
    {
        int id = reader.GetInt32(0);
        string Name = reader.GetString(1);
        string Pass = reader.GetString(2);  
        literalID.text += id.ToString();
        literalName.text += Name.ToString();
        literalPass.text += Pass.ToString();
    }

this is the easiest solution I know, but it's not neat.
here's the html code:

<tr align="left" style="background-color:#004080;color:White;" >
    <td> ID </td>                        
    <td> Name </td>            
    <td>Pass</td>                        
</tr>
<tr align="left" style="background-color:#004080;color:White;" >
    <td><asp:Literal ID="literalID" runat="server"></asp:Literal></td>                        
    <td><asp:Literal ID="literalName" runat="server"></asp:Literal></td>            
    <td><asp:Literal ID="literalPass" runat="server"></asp:Literal></td>   
</tr>

edited Dec 13, 2012 at 13:26

answered Dec 13, 2012 at 13:14

Mahdi Tahsildari

13.8k14 gold badges57 silver badges97 bronze badges

4 Comments

riad Over a year ago

can you please help me to write the html part?? because i can't get you , how to write the html part.

riad Over a year ago

Sorry, it's showing all data into a single row.But i need multipul row.I mean all available row in database.

Mahdi Tahsildari Over a year ago

@riad if you have gotten the point, you can dynamically add table rows and columns and assign each row a value, if you still have trouble tell me to add the code.

Chris Over a year ago

Down-voted because doesn't this just concatenate the strings of every database row into a single table row?!

Saeed Dini · Accepted Answer · 2017-10-24 07:14:54Z

0

In this solution , all HTML tags create in client Side and client have to render this processes instead of server. this is a better idea and give best performance for your server then use this code:

<asp:Content ID="BodyContent" runat="server" 
 ContentPlaceHolderID="ContentPlaceHolder">
     <table width="100%" align="center" cellpadding="2" cellspacing="2" border="0" bgcolor="#EAEAEA" >
         <tr align="left" style="background-color:#004080;color:White;" >
             <td> ID </td>                        
             <td> Name </td>            
            <td>Pass</td>                        
         </tr>

       <% if(dt != null && dt.rows.count>0){
              foreach(var item in dt.rows)
                 {%>
                   <tr>
                      <td><%=item["ID"]%></td>
                      <td><%=item["Name"]%></td>
                      <td><%=item["Pass"]%></td>
                   </tr>
                  <%}
                }%>

     </table> </asp:Content>

edited Oct 24, 2017 at 7:14

answered Oct 23, 2017 at 14:24

Saeed Dini

1231 silver badge22 bronze badges

1 Comment

GrumpyCrouton Over a year ago

Thank you for this code snippet, which may provide some immediate help. A proper explanation would greatly improve its educational value by showing why this is a good solution to the problem, and would make it more useful to future readers with similar, but not identical, questions. Please edit your answer to add explanation, and give an indication of what limitations and assumptions apply.

Collectives™ on Stack Overflow

Show data in ASP.NET html table

5 Answers 5

5 Comments

Comments

1 Comment

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

5 Comments

Comments

1 Comment

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related