Dynamic Html Table

Question

Hi

Can the below code can be done dynamically. Tables & no of fields van be different. Now i have to write in every file

StringBuilder htmlTable = new StringBuilder();
con.ConnectionString = ConfigurationManager.ConnectionStrings["cnn_Live"].ConnectionString; ;
SqlCommand cmd = new SqlCommand("select * from EmployeeCategory order by Category", con);
cmd.CommandType = CommandType.Text;
if (con.State == ConnectionState.Closed)
{
    con.Open();
}
SqlDataAdapter sda = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
    Int32 Count = 1;
    htmlTable.Append("<table class='table table-bordered table-hover datatable-highlight' id='tbldata'>");
    htmlTable.Append("<thead><tr style='background-color:green;color:white; text-align: center;'><th>Sr.</th><th>Name</th><th>Short Name</th><th>Status</th><th class='text-center nosort'>Action</th><th style='display:none'</th><th style='display:none'</th></tr></thead>");
    htmlTable.Append("<tbody>");
    foreach (DataRow row in dt.Rows)
    {
        String Status = "Blocked";
        if (Convert.ToBoolean(row["status"]))
        {
            Status = "Active";
        }

        htmlTable.Append("<tr>");
        htmlTable.Append("<td>" + Count.ToString() + "</td>");
        htmlTable.Append("<td>" + row["category"] + "</td>");
        htmlTable.Append("<td>" + row["shortname"] + "</td>");
        if (Status == "Active")
            htmlTable.Append("<td class='text-center'><a  id='btnStatus' class='badge bg-primary'>" + Status + "</a></td>");
        else
            htmlTable.Append("<td class='text-center'><a  id='btnStatus' class='badge bg-danger'>" + Status + "</a></td>");

        htmlTable.Append("<td class='text-center'>");
        htmlTable.Append("<a id='btnEdit' class='list-icons-item text-primary-600' data-toggle='modal' data-backdrop='static' data-keyboard='false' data-target='#modal_form_horizontal' onclick='BindData(this);'><i class='icon-pencil7 mr-1'></i></a>");

        string deleteAttributes = Status == "Blocked" ? "style='pointer-events: none; opacity: 0.5;' onclick='return false;'" : "data-toggle='modal' data-target='#modal_Delete' onclick='BindData(this);'";
        htmlTable.Append($"<a id='btnDel' class='list-icons-item text-danger-600' {deleteAttributes}><i class='icon-bin mr-1'></i></a>");

        htmlTable.Append("</td>");
        

        htmlTable.Append("<td style='display:none'>" + row["docentry"] + "</td>");
        htmlTable.Append("<td style='display:none'>" + row["status"] + "</td>");
        htmlTable.Append("</tr>");
        Count++;
    }
    htmlTable.Append("</tbody>");
    htmlTable.Append("</table>");
    PlaceHolderTable.Controls.Add(new Literal { Text = htmlTable.ToString() });

Thanks

Naimish Makwana · Answer

Yes, you can make this code more dynamic to handle different tables and fields. Here’s an example of how you can achieve this by using reflection and a more generic approach: using System; using System.Data; using System.Data.SqlClient; using System.Configuration; using System.Text; using System.Web.UI.WebControls; public void GenerateHtmlTable(string tableName) { StringBuilder htmlTable = new StringBuilder(); string connectionString = ConfigurationManager.ConnectionStrings["cnn_Live"].ConnectionString; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand($"SELECT * FROM {tableName} ORDER BY 1", con); cmd.CommandType = CommandType.Text; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { htmlTable.Append(" "); htmlTable.Append(" "); // Add table headers dynamically foreach (DataColumn column in dt.Columns) { htmlTable.Append($" {column.ColumnName} "); } htmlTable.Append(" Action "); htmlTable.Append(" "); int count = 1; foreach (DataRow row in dt.Rows) { htmlTable.Append(" "); htmlTable.Append($" {count} "); foreach (DataColumn column in dt.Columns) { htmlTable.Append($" {row[column.ColumnName]} "); } string status = Convert.ToBoolean(row["status"]) ? "Active" : "Blocked"; string statusClass = status == "Active" ? "bg-primary" : "bg-danger"; htmlTable.Append($" {status} "); htmlTable.Append(" "); htmlTable.Append(" "); string deleteAttributes = status == "Blocked" ? "style='pointer-events: none; opacity: 0.5;' onclick='return false;'" : "data-toggle='modal' data-target='#modal_Delete' onclick='BindData(this);'"; htmlTable.Append($" "); htmlTable.Append(" "); htmlTable.Append(" "); count++; } htmlTable.Append(" "); htmlTable.Append(" "); } } PlaceHolderTable.Controls.Add(new Literal { Text = htmlTable.ToString() }); } Key Changes: Dynamic Table and Column Handling : The table name is passed as a parameter, and columns are dynamically added based on the DataTable schema. Status Handling : The status is determined dynamically based on the row data. Generic HTML Generation : The HTML generation is more generic, making it easier to adapt to different tables and fields. This approach should help you avoid writing repetitive code for different tables and fields. Thanks

Gowtham Cp · Answer

Hello Ramco Ramco , To create a dynamic HTML table in C#, follow these steps: Fetch Data : Load your data from the database into a DataTable . Build the Table : Use StringBuilder to construct the HTML. Generate table headers and rows based on the DataTable content. Here’s a simplified example: using System; using System.Data; using System.Data.SqlClient; using System.Text; using System.Web.UI.WebControls; public partial class YourPage : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { GenerateDynamicTable(); } private void GenerateDynamicTable() { StringBuilder htmlTable = new StringBuilder(); string connectionString = ConfigurationManager.ConnectionStrings["cnn_Live"].ConnectionString; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SELECT * FROM EmployeeCategory ORDER BY Category", con); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { htmlTable.Append(" "); // Create headers htmlTable.Append(" "); foreach (DataColumn column in dt.Columns) { htmlTable.Append($" {column.ColumnName} "); } htmlTable.Append(" Action "); htmlTable.Append(" "); // Create rows htmlTable.Append(" "); int count = 1; foreach (DataRow row in dt.Rows) { string status = Convert.ToBoolean(row["status"]) ? "Active" : "Blocked"; string statusClass = status == "Active" ? "badge bg-primary" : "badge bg-danger"; string deleteAttributes = status == "Blocked" ? "style='pointer-events: none; opacity: 0.5;' onclick='return false;'" : "data-toggle='modal' data-target='#modal_Delete' onclick='BindData(this);'"; htmlTable.Append(" "); htmlTable.Append($" {count} "); foreach (DataColumn column in dt.Columns) { if (column.ColumnName == "status") { htmlTable.Append($" {status} "); } else { htmlTable.Append($" {row[column]} "); } } htmlTable.Append(" "); htmlTable.Append(" "); htmlTable.Append($" "); htmlTable.Append(" "); htmlTable.Append(" "); count++; } htmlTable.Append(" "); htmlTable.Append(" "); PlaceHolderTable.Controls.Add(new Literal { Text = htmlTable.ToString() }); } } } } Hope it helps!

Aman Gupta · Answer

Hi Ramco, Yes, you can make this code more dynamic to handle different tables and fields. Here’s an approach that can help you achieve that: Parameterize the SQL Query: Pass the table name and fields dynamically. Generate the Table Header Dynamically: Based on the columns returned by the query. Generate the Rows Dynamically: Loop through the columns and create table rows accordingly. Here’s a modified version of your code: public void GenerateDynamicTable(string tableName, string[] fields, string orderByField) { StringBuilder htmlTable = new StringBuilder(); con.ConnectionString = ConfigurationManager.ConnectionStrings["cnn_Live"].ConnectionString; string query = $"SELECT {string.Join(", ", fields)} FROM {tableName} ORDER BY {orderByField}"; SqlCommand cmd = new SqlCommand(query, con); cmd.CommandType = CommandType.Text; if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { int count = 1; htmlTable.Append(" "); // Dynamically generate the table header htmlTable.Append(" Sr. "); foreach (DataColumn column in dt.Columns) { if (column.ColumnName != "docentry" && column.ColumnName != "status") { htmlTable.Append($" {column.ColumnName} "); } } htmlTable.Append(" Action "); htmlTable.Append(" "); htmlTable.Append(" "); htmlTable.Append(" "); htmlTable.Append(" "); foreach (DataRow row in dt.Rows) { string status = Convert.ToBoolean(row["status"]) ? "Active" : "Blocked"; htmlTable.Append(" "); htmlTable.Append($" {count} "); foreach (var field in fields) { htmlTable.Append($" {row[field]} "); } // Status column if (status == "Active") htmlTable.Append(" " + status + " "); else htmlTable.Append(" " + status + " "); // Action buttons htmlTable.Append(" "); htmlTable.Append(" "); string deleteAttributes = status == "Blocked" ? "style='pointer-events: none; opacity: 0.5;' onclick='return false;'" : "data-toggle='modal' data-target='#modal_Delete' onclick='BindData(this);'"; htmlTable.Append($" "); htmlTable.Append(" "); htmlTable.Append($" {row["docentry"]} "); htmlTable.Append($" {row["status"]} "); htmlTable.Append(" "); count++; } htmlTable.Append(" "); htmlTable.Append(" "); PlaceHolderTable.Controls.Add(new Literal { Text = htmlTable.ToString() }); } } Explanation: GenerateDynamicTable Method: Takes the table name, fields, and the order-by field as parameters. Dynamic SQL Query: Builds the SQL query dynamically based on the provided table name and fields. Dynamic Header Generation: Loops through the columns returned by the query and creates headers dynamically. Dynamic Row Generation: Loops through each row and each field, creating the rows accordingly. Usage Example: string[] fields = { "category", "shortname", "status", "docentry" }; GenerateDynamicTable("EmployeeCategory", fields, "Category"); This will help you Ramco. Thanks

Dynamic Html Table

Answers (3)