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

Snake Xenzia

Hello friends did you remember the GAME you play on nokia 1100 , SNAKE XENZIA .Yeah the same you are thinking ,a snake eating food and go longer and longer till it dies. Why to play it on mobile when it is available on your pc ??? It is made in .net framework 4.0 .Just install the setup and play SNAKE XENZIA . Have Fun !! DOWNLOAD IT   HERE  . Related articles Rattlesnake Dreams "Classsic Snake Game In C"? Resident Evil 6 gamescom demo takes in a giant snake battle Snakes & ladders
5 comments
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

10 home remedies for acidity that really work!

All of us have suffered from acidity at some point in our lives. Either it is that extra  gulab jamun  at a family function or that spicy  samosa  during tea break. Whatever the reason may be, acidity can be quite an uncomfortable experience, and sometimes we are left with no option but to reach out for that bottle of antacid. But, did you know that there are alternative, n                        atural remedies that work just as well and don’t leave you with the ill-effects of too much medication? Read about the  new-age technique to relieve the symptoms of acidity .  Here are 10 things to treat acidity and its recurrence at bay:   Bananas : Are high in potassium which is an alkalizing mineral that has a high pH value. The higher the pH value, the lower the acidity, which is  why the banana is a formidable antidote for acidity. They also have a component that makes the stomach...
Post a Comment
Read more