How to create html table from code behind?

First of all thanks for taking your interest in my article.Here I am describing how to create html table from code behind and store data in it.
STEP 1:
first of all take the Asp.net empty web application from project template and give it any name.

STEP 2:
Now add a new webform to the website by right clicking the project name>add new item>choose webform>
give the name to the webform as Default.aspx
and click add.

STEP3:
as your .net set up is complete now open sqlserver management studio.
Create a database having name html and add a table having name thtml to it.
thtml contains three columns id,name,rollno. fill some data in the table.

for creating database open new query window and paste the below query:
create database html
select this query and execute this will creat the database having name html.

Now we have to add the table to it.so right click your database name select new query and create the table with below query:

create table thtml(id int,name varchar(50),rollno varchar(50))
select the full query and click execute.this will create the table having name thtml of three columns id,name,rollno.We will show the record of this table into html table.

now fill some data in it with

insert into thtml(id,name,rollno) values(1,'firstname','123')
insert into thtml(id,name,rollno) values(2,'hello','786')
insert into thtml(id,name,rollno) values(3,'ram','89')
insert into thtml(id,name,rollno) values(4,'seema','97')
insert into thtml(id,name,rollno) values(5,'kabir','234')
Now your database work is complete

STEP 4:
AS our database work in complete,back to .net open default.aspx.cs.

here we will write our code.
First of all add two name spaces at the top of page:

using System.Data;
using System.Data.SqlClient;
 

 public void createtable()
    {
        SqlConnection con = new SqlConnection(@"Paste Your ConnectionString  here");
        con.Open();
        SqlCommand cmd = new SqlCommand("select name,rollno from thtml", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        con.Close();
        DataTable dt = new DataTable();
        da.Fill(dt);

        //now we filled our data table
        //below is the code to create html table
        string t = string.Empty;
        t = "";
        t += "";
        for (int i = 0; i <= dt.Rows.Count - 1; i++)
        {
            t += "";
        }
        t += "
Name
Rollno
" + dt.Rows[i]["name"].ToString() + "
" + dt.Rows[i]["rollno"].ToString() + "
";
        Response.Write(t);
    }
 

  protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            createtable();
        }
    }