Html helper bynamic table bind for DataTable and generic list model

- 
 Html Helper with DataTable
 
public static MvcHtmlString ToHtmlTable(this HtmlHelper html, DataTable dataTable)
       {
           StringBuilder tempTableSb = new StringBuilder();
           if (dataTable != null && dataTable.Rows.Count > 0)
           {
               tempTableSb.Append("<table class='table table - responsive table - bordered'>");
               tempTableSb.Append("<thead><tr>");
               foreach (DataColumn col in dataTable.Columns)
               {
                   tempTableSb.Append("<th>" + col.Caption + "</th>");
               }
               tempTableSb.Append("</tr></thead><tbody>");
               foreach (DataRow row in dataTable.Rows)
               {
                   tempTableSb.Append("<tr>");
                   foreach (var cell in row.ItemArray)
                   {
                       tempTableSb.Append("<td>" + cell.ToString() + "</td>");
                   }
                   tempTableSb.Append("</tr>");
               }
               tempTableSb.Append("</tbody></table>");
           }
           else
           {
               tempTableSb.Append("<div class='text-danger> Data not found </div>");
           }
 
           return new MvcHtmlString(tempTableSb.ToString());
 
       }
       
 
 Html Helper with Model
 
         public static MvcHtmlString ToHtmlTable<T>(this HtmlHelper html, List<T> data)
       {
           StringBuilder tempTableSb = new StringBuilder();
           if (data != null && data.Count > 0)
           {
               tempTableSb.Append("<table class='table table - responsive table - bordered'>");
               tempTableSb.Append("<thead><tr>");
               PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(typeof(T));
               foreach (PropertyDescriptor prop in properties)
                   tempTableSb.Append("<th>" + prop.Name + "</th>");
 
               tempTableSb.Append("</tr></thead><tbody>");
               foreach (T item in data)
               {
                   tempTableSb.Append("<tr>");
                   foreach (PropertyDescriptor prop in properties)
                       tempTableSb.Append("<td>" + prop.GetValue(item) + "</td>");
 
                   tempTableSb.Append("</tr>");
               }
               tempTableSb.Append("</tbody></table>");
           }
           else
           {
               tempTableSb.Append("<div class='text-danger> Data not found </div>");
           }
 
           return new MvcHtmlString(tempTableSb.ToString());
 
       }
 
       public static string ToHtmlTables<T>(List<T> data)

Comments

Post a Comment

Popular posts from this blog

Form submit resulting in “InvalidDataException: Form value count limit 1024 exceeded.” In ASP.NET Core

-
You can change the default formvalue limit using the   FormOptions . If you are using MVC, then you can create a filter and decorate on action where you want to extend this limit and keep the default for rest of the actions. namespace Filter {     using System;     using Microsoft.AspNetCore.Http.Features;     using Microsoft.AspNetCore.Mvc.Filters;     /// <summary>     /// Request Form Size Limit Attribute     /// </summary>     /// <seealso cref="System.Attribute" />     /// <seealso cref="Microsoft.AspNetCore.Mvc.Filters.IAuthorizationFilter" />     /// <seealso cref="Microsoft.AspNetCore.Mvc.Filters.IOrderedFilter" />     [AttributeUsage(AttributeTargets.Class | AttributeTargets.Method, AllowMultiple = false, Inherited = true)]     public class RequestFormSizeLimitAttribute : Attri...
Read more

What is the importance of EDMX file in Entity Framework

-
Image
ADO.NET entity is an ORM (object relational mapping) which creates a higher abstract object model over ADO.NET components. So rather than getting into dataset, datatables, command, and connection objects as shown in the below code, you work on higher level domain objects like customers, suppliers, etc. DataTable table = adoDs.Tables[ 0 ]; for ( int j = 0 ; j < table.Rows.Count; j++) { DataRow row = table.Rows[j]; // Get the values of the fields string CustomerName = ( string )row[ " Customername" ]; string CustomerCode = ( string )row[ " CustomerCode" ]; }   Benefits of using EF The main and the only benefit of EF is it auto-generates code for the Model (middle layer), Data Access Layer, and mapping code, thus reducing a lot of development time. The importance of EDMX file in Entity Framework    EDMX (Entity Data Model XML) is an XML file which contains all the mapping details of how your objects map ...
Read more