how to connect database to bootstrap html table in asp webfo

Oladotun Obileye

Good day everyone i am working on a project on asp.net webform. i am using a template that has an already made table so i want to collect the table to the database so it can fetch out all the information and send it to the table.

StringBuilder table = new StringBuilder();
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\odt\Documents\login.mdf;Integrated Security=True;Connect Timeout=30");
;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from [log] ";
cmd.Connection = con;
SqlDataReader dt = cmd.ExecuteReader();
if (dt.HasRows)
{
if (dt.Read())
{
}
}
// cmd.ExecuteNonQuery();
con.Close();
}

this is the html table

<div class="box-body table-responsive no-padding">
<table ID="tdb" class="table table-hover" >
<tr>
<th>IDth>
<th>Userth>
<th>Passwordth>

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Bhoir7y ago
Hi Oladotun,

You can implement the same logic which is mentioned in below article without changing your HTML table design.

https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/

Just try to implement the logic given in this article to bind data with HTML Table without chaning the design.
0
Oladotun Obileye7y ago
thanks but i have a template if i should it according what is in
https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/
will the bootstrap table design still be there
+1
Anoop Kumar Sharma7y ago
Hi Oladotun,

You need to perform the below steps in order to bind the data to the table (grid view as you said you are using web form) with bootstrap classes for the UI.
1. Get the data from the database to the data table.
2. Bind that Datatable with Gridview as the source.
3. Download and include (via NuGet/or manually) Bootstrap CSS and JS.
4. Apply the classes on the grid view in order to make it responsive (same as we apply on tables).

For Detailed step by step approach, I will recommend you to check the below article:
https://www.c-sharpcorner.com/UploadFile/47548d/responsive-grid-view-in-Asp-Net/

Hope this will help you.
+1
Nilesh Sawardekar7y ago
perfect solution for you,

https://www.c-sharpcorner.com/UploadFile/rahul4_saxena/showing-table-data-in-dynamically-created-table-in-Asp-Net-c/
+1