aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Display Data in HTML Table from Database using in C#, VB.NET

Dec 21, 2014

Here I will explain how to display data from database in HTML Table in using c# and or show data in HTML table from database using in c# and

In previous articles I explained jQuery play youtube videos in, Access HTML selected value from dropdownlist in, Remove tab index or tab focums for HTML elements in  and many articles relating to HTML,, c#, and jQuery. Now I will explain how to display data from database in HTML Table in using c# and controls like the gridview are processed on the server and then the results are translated into HTML and JavaScript before it is sent to the browser.  An html table can be read directly by a browser, so there is no need to translate it.

So directly using HTML table for displaying data from database is most effective rather than gridview in terms of Performance.

But for some operations like sorting, searching we should prefer GridView or some other server side data controls.

Before implement this example first design one table UserInfo in your database as shown below

Column Name
Data Type
Allow Nulls
Int(Set IDENTITY Property =TRUE)
Not Null
Once table created in database enter some dummy data to test application that would be like as shown below

Now open your aspx page and write the following code

<html xmlns="">
<head runat="server">
<title>Display Data from Database in HTML Table in</title>
<form id="form1" runat="server">
<asp:PlaceHolder id="PlaceHolder1" runat="server"></asp:PlaceHolder>
If you observe above code we added PlaceHolder that will acts content holder for our html content

Now open code behind file and add following namespaces

C# Code

using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using System.Web.UI.WebControls;

Imports System.Data
Imports System.Data.SqlClient
Imports System.Text
Imports System.Web.UI.WebControls

After that add following code to export datagridview data to excel

C# Code

SqlConnection scon = new SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB");
StringBuilder htmlTable = new StringBuilder();
protected void Page_Load(object sender, EventArgs e)
if (!IsPostBack)
using (SqlCommand scmd = new SqlCommand())
scmd.Connection = scon;
scmd.CommandType = CommandType.Text;
scmd.CommandText = "SELECT * FROM UserInfo";
SqlDataReader articleReader = scmd.ExecuteReader();

htmlTable.Append("<table border='1'>");
htmlTable.Append("<tr><th>SlNo.</th><th>Name</th><th>Mobile Number</th><th>EmailId</th></tr>");

if (articleReader.HasRows)
while (articleReader.Read())
htmlTable.Append("<td>" + articleReader["ID"]+ "</td>");
htmlTable.Append("<td>" + articleReader["Name"] + "</td>");
htmlTable.Append("<td>" + articleReader["Mobno"] + "</td>");
htmlTable.Append("<td>" + articleReader["EmailId"] + "</td>");

PlaceHolder1.Controls.Add(new Literal { Text = htmlTable.ToString() });



Imports System.Data
Imports System.Data.SqlClient
Imports System.Text
Imports System.Web.UI.WebControls
Partial Class VBCode
Inherits System.Web.UI.Page
Private scon As New SqlConnection("Data Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB")
Private htmlTable As New StringBuilder()
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Using scmd As New SqlCommand()
scmd.Connection = scon
scmd.CommandType = CommandType.Text
scmd.CommandText = "SELECT * FROM UserInfo"
Dim articleReader As SqlDataReader = scmd.ExecuteReader()
htmlTable.Append("<table border='1'>")
htmlTable.Append("<tr><th>SlNo.</th><th>Name</th><th>Mobile Number</th><th>EmailId</th></tr>")

If articleReader.HasRows Then
While articleReader.Read()
htmlTable.Append("<td>" & Convert.ToString(articleReader("ID")) & "</td>")
htmlTable.Append("<td>" & Convert.ToString(articleReader("Name")) & "</td>")
htmlTable.Append("<td>" & Convert.ToString(articleReader("Mobno")) & "</td>")
htmlTable.Append("<td>" & Convert.ToString(articleReader("EmailId")) & "</td>")
End While

PlaceHolder1.Controls.Add(New Literal() With { _
Key .Text = htmlTable.ToString() _

End If
End Using
End If
End Sub
End Class
Now run your code and check output that will be like as shown below


If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Anonymous said...

in which case we use html directory table

Anonymous said...

Thank you very much brother... keep it up..God bless u (y)

Gunwant Chirmade said...

How to declare PlaceHolder1 in program

Anonymous said...

Sir can u please tell how to adda dropdown list to the HTMS table and bind data from database?
Thanks in advance.

Unknown said...

sir how to edit,delete records in this table and database.
Thanks in advance.

Rana Sohel said...

it shows my data.
But problem is my table design is broken.
Like right side bootstrap paging, search option etc.
is there any solution

Give your Valuable Comments

Other Related Posts

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.