Skip to main content

Convert a DataTable to HTML

The Following function will return a HTML formatted string for the given dataset.

Some line are commented, you can remove comments if you need.


  1. DataTable dtPriceDetails = SOME DATA TABLE   
  3. if (dt.Rows.Count > 0)  
  4. {  
  5. string StringDataTable = ConvertToHtmlFile(dtPriceDetails);  
  6. }  
  8.   public static string ConvertToHtmlFile(DataTable targetTable)  
  9.   {  
  10.     string myHtmlFile = "";  
  12. if (targetTable == null)  
  13.       {  
  14.         throw new System.ArgumentNullException("targetTable");  
  15. }  
  16.       else  
  17.       {  
  18.         //Continue.   
  19. }  
  21. //Get a worker object.  
  22.       StringBuilder myBuilder = new StringBuilder();  
  24.       //Open tags and write the top portion.   
  25.       //myBuilder.Append("");  
  26.       //myBuilder.Append("");  
  27.       //myBuilder.Append("");  
  28.       //myBuilder.Append("");  
  29.       //myBuilder.Append("");  
  30.       myBuilder.Append(");  
  31.       myBuilder.Append("style='border: solid 1px Silver; font-size: x-small;'>");  
  33. //Add the headings row.  
  34.       myBuilder.Append("");  
  35. foreach (DataColumn myColumn in targetTable.Columns)  
  36.       {  
  37.         myBuilder.Append("");  
  38.       myBuilder.Append(myColumn.ColumnName);  
  39.         myBuilder.Append("");  
  40.       }  
  41.       myBuilder.Append("");  
  43. //Add the data rows.   
  44.       foreach (DataRow myRow in targetTable.Rows)  
  45.       {  
  46.         myBuilder.Append("");  
  48. foreach (DataColumn myColumn in targetTable.Columns)  
  49.             {  
  50.                 myBuilder.Append("");  
  51.                   myBuilder.Append(myRow[myColumn.ColumnName].ToString());  
  52.                   myBuilder.Append("");  
  53. }  
  55.             myBuilder.Append("");  
  56. }  
  58.       //Close tags.   
  59.       myBuilder.Append("");  
  60.       //myBuilder.Append("");   
  61.       //myBuilder.Append("");  
  63.       //Get the string for return.   
  64.       myHtmlFile = myBuilder.ToString();  
  66.       return myHtmlFile;  
  67. }  

HTML Tags ChartHTML Utopia: Designing Without Tables Using CSSHTML Essential TrainingCreating Web Sites: The Missing Manual


Popular posts from this blog

Call User-defined Function on Linked Server :SQL Server

If you try to invoke a user-defined function (UDF) through a linked server in SQL Server by using a "four-part naming" convention (server.database.dbo.Function), you may receive error message.  The reason is User-defined function calls inside a four-part linked server query are not supported in SQL Server. Thats why error message indicates that the syntax of a Transact-SQL statement is incorrect.  To work around this problem, use the Openquery function instead of the four-part naming convention. For example, instead of the following query Select * from Linked_Server.database.dbo.Function(10) run a query with the Openquery function: Select * from Openquery(Linked_Server,'select database.dbo.Function(10)') If the user-defined function takes variable or scalar parameters, you can use the sp_executesql stored procedure to avoid this behavior.  For example: exec Linked_Server.database.dbo.sp_executesql N'SELECT database.dbo.Function(@input)',N'@input

Installing the FrontPage Server Extensions on IIS 7.0

As most people that have installed IIS 7.0 on Windows Vista and Windows Server© 2008 have realized, there are no options to install the FrontPage Server Extensions, leaving only two ways to edit your Web site if it is hosted on a Windows Vista or Windows Server 2008 computer: Edit the Web site locally by using the file system. Use FTP to upload your files to a remote Windows Vista or Windows Server 2008 computer. Microsoft realizes that the FrontPage Server Extensions are essential to many Web hosting companies and developers, and has worked with Ready-to-Run Software to release a version of the FrontPage 2002 Server Extensions (FPSE 2002) for Windows Vista and Windows Server 2008. This version of FPSE 2002 is available for x86 (32-bit) and x64 (64-bit) Windows Vista and Windows Server 2008 as a separate download for IIS 7.0, and you can download this version by clicking the following URL: FrontPage 2002 Server Extensions for IIS 7.0 Notes: The FrontPage 2002 Server Extensions (

Pass multiple complex objects to Web API action

Working with ASP.NET Web API, the most unexpected thing is the limited support of POST data values to simple ApiController methods. When a parameter has [FromBody], Web API uses the Content-Type header to select a formatter. At most one parameter is allowed to read from the message body. The reason for this rule is that the request body might be stored in a non-buffered stream that can only be read once. A simple principle, you can send any content in HTTP request, it only need to be serializable into a string. So, it could be multiple JSON object. In this example, the content type is "application/json" and the request body is a raw JSON string (not a JSON object). Here I found a workaround to pass multiple complex objects (using the above principle) from jquery to a WEB API using JObject , and then cast back to your required specific object type in api controller. This objects provides a concrete type specifically designed for working with JSON. var customer = { &quo