Skip to main content

create html table from datatable asp.net

Code:


    public string CreateHtmlTableRows(DataTable targetTable, string strtblName, string uniquenumber)
    {
        StringBuilder myBuilder = new StringBuilder();
        myBuilder.Append("<div id='printdiv'  style='padding-top:20px;'>");
        if (strtblName != "")
            myBuilder.Append("<table Id='" + strtblName + "' border='1px' cellpadding='0' cellspacing='0' ");
        else
            myBuilder.Append("<table border='1px' cellpadding='0' cellspacing='0' ");
        myBuilder.Append("style='width: 100%;'>");
        // adding main static text
        myBuilder.Append("<tr align='center' valign='top' style='font-size:17px;font-family:Times New Roman, Times, serif;font-weight:bold;'>");

        myBuilder.Append("<td align='center' valign='center' colspan='2' height='30'>");
        myBuilder.Append("Client Name:");
        myBuilder.Append("</td>");

        myBuilder.Append("<td align='center' valign='center' colspan='3' height='30'>");
        myBuilder.Append("Lovely Faculty of Open and Distance Learning");
        myBuilder.Append("</td>");

        myBuilder.Append("<td align='center' valign='center' colspan='2' height='30'>");
        myBuilder.Append("Deposit No.:");
        myBuilder.Append("</td>");

        myBuilder.Append("<td align='center' valign='center' colspan='2' height='30'>");
        myBuilder.Append(uniquenumber); // here autogenerated number
        myBuilder.Append("</td>");

        myBuilder.Append("<td align='center' valign='center' colspan='2' height='30'>");
        myBuilder.Append("Re Registration");
        myBuilder.Append("</td>");
        myBuilder.Append("</tr>");




        myBuilder.Append("<tr align='center' valign='top'style='font-size:17px;font-family:Times New Roman, Times, serif;font-weight:bold;'>");

        myBuilder.Append("<td align='center' valign='center' colspan='2' height='30'>");
        myBuilder.Append("Client Code:");
        myBuilder.Append("</td>");

        myBuilder.Append("<td align='center' valign='center' colspan='3' height='30'>");
        myBuilder.Append("LVFOPNDRR");
        myBuilder.Append("</td>");

        myBuilder.Append("<td align='center' valign='center' colspan='2' height='30'>");
        myBuilder.Append("Deposit Date:");
        myBuilder.Append("</td>");

        myBuilder.Append("<td align='center' valign='center' colspan='2' height='30'>");
        string date = DateTime.Now.ToString("MM/dd/yyyy");
        ViewState["date"] = date;
        myBuilder.Append(date); // here autogenerated number
        myBuilder.Append("</td>");

        myBuilder.Append("<td align='center' valign='center' colspan='2' height='30'>");
        myBuilder.Append("");
        myBuilder.Append("</td>");
        myBuilder.Append("</tr>");


        //Add the headings row.
        myBuilder.Append("<tr align='center' valign='top' style='font-size:12px;'>"); //grdHeader class will be in CSS file

        foreach (DataColumn myColumn in targetTable.Columns)
        {
            myBuilder.Append("<td align='center' valign='top'>");
            myBuilder.Append(myColumn.ColumnName);
            myBuilder.Append("</td>");
        }
        myBuilder.Append("</tr>");
        //Add the data rows.
        int intI = 0;
        int totRow = targetTable.Rows.Count - 1;
        foreach (DataRow myRow in targetTable.Rows)
        {

            if (intI % 2 == 0)
                myBuilder.Append("<tr align='center' style='font-size:11px;'>"); //'grdOddRow'class will be in CSS file
            else
                myBuilder.Append("<tr align='center' style='font-size:11px;'>"); //''grdEvenRow''class will be in CSS file

            foreach (DataColumn myColumn in targetTable.Columns)
            {
                myBuilder.Append("<td align='left' valign='bottom' height='10'><b>");
                myBuilder.Append(myRow[myColumn.ColumnName].ToString());
                myBuilder.Append("</b></td>");
            }
            myBuilder.Append("</tr>");
            intI += 1;
        }
        //Close tags.
        return myBuilder.Append("</table></div>").ToString();

    }

Comments

Post a Comment

Popular posts from this blog

show image in asp.net form from database

In order to show image from database to webform first add an image control in webpage.   <asp:Image ID="imgStudentImage" runat="server" Height="157px" Width="160px" /> Then add new webform to read image from database for example displayimage.aspx and in code behind model write the following code. public string str = //your string     public SqlConnection conn;     public SqlCommand sql = new SqlCommand();     public SqlDataReader dr;     public string strSQL;     protected void Page_Load(object sender, EventArgs e)     {         conn = new SqlConnection(str);         conn.Open();         long id = Convert.ToInt64(Request.QueryString["mId"]);         strSQL = "";         strSQL = strSQL + " SELECT snap from S...
Post a Comment
Read more

Export Doc,Access,Image,CSV,Excel,Pdf,XML,HTML,Text,Print of Gridview in Asp.net

First import itextsharp.dll in the solution and use three namespces (basically for pdf) using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser;          Then Use the following code :- on each button  click  protected void Page_Load(object sender, EventArgs e)         {             if (!Page.IsPostBack)             {                 BindGridDetails(GridView1);             }         }                 protected DataTable BindGridDetails(GridView GridView1)         {   ...
1 comment
Read more

Advent of code 2022 day 22 part 1

  function main(input, input1) {     let grid = input.split( '\n' );     grid.shift();     // only in big input     for ( let i = 0 ; i < 100 ; i++) {         grid[i] = '                                                  ' + grid[i];     }     //console.log(grid[100])     grid = grid.map(x => x.split( '' ))     // find first left top allowed     let temppos = - 1 ;     grid[ 0 ].forEach((element, i) => {         if (temppos == - 1 && element == '.' ) {             temppos = i;         }     });     let initpos = new pos(temppos, 0 )     // console.log(initpos)     // make grid equal shape     let...
Post a Comment
Read more