Is it possible to StreamWrite the DataList Result to make an HTML file? (ASP.Net)

Question

Here is my example code on what I am trying to do, can you give an example syntax to make this possible?

The query select will run to show data on datalist and after that if button is click the results will be written to an HTML file.

Page Load

  protected void Page_Load(object sender, EventArgs e)
            {
                if (!IsPostBack)
                {
                    DataList();
                }
            }

Data List

public void DataList()
               {
                 String testcon = System.Configuration.ConfigurationManager.ConnectionStrings["TestConnection"].ToString();
                    MySqlConnection con = new MySqlConnection(testcon );
                    con.Open();
                    MySqlCommand cmd = con.CreateCommand();
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = "SELECT * From ExampleTable";
                    cmd.ExecuteNonQuery();
                    DataSet ds = new DataSet();
                    MySqlDataAdapter da = new MySqlDataAdapter(cmd);
                    da.Fill(ds);
                    DataList1.DataSource = ds;
                    DataList1.DataBind();

                    con.Close();
            }

Button Click

 protected void Button1_Click(object sender, EventArgs e)
        {
            string path = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
            using (FileStream fs = new FileStream((path + "\\Sample.html"), FileMode.Create))
            {
                using (StreamWriter w = new StreamWriter(fs, Encoding.UTF8))
                {
                    w.WriteLine("<html>");
                    w.WriteLine("</head>");
                    w.WriteLine("<body>");
                    w.WriteLine("DataList(ItemTemplate)");
                    w.WriteLine("</body>");
                    w.WriteLine("</html>");
                }
                LabelDisplay.Text = "File Successfully Created @ " + ((path + "\\Sample.html"));
            }

        }

if RenderControl can get the HTML string of DataList, then that is what I am looking for. — Raniel Quirante
– Raniel Quirante, Commented Apr 3, 2018 at 10:51
but, will this work if I StreamWrite the DataList to become an HTML file? — Raniel Quirante
– Raniel Quirante, Commented Apr 3, 2018 at 10:53
You can get the html in a string like in the link I gave you. — Crowcoder
– Crowcoder, Commented Apr 3, 2018 at 10:55

vivek ramasamy · Accepted Answer · 2018-04-03 10:57:34Z

2

Session["DataList"] = ds.tables[0];

You can copy paste the below method which will convert the datatable to the html string.

protected string ExportDatatableToHtml(DataTable dt)  
{  
    StringBuilder strHTMLBuilder = new StringBuilder();  
    strHTMLBuilder.Append("<html >");  
    strHTMLBuilder.Append("<head>");  
    strHTMLBuilder.Append("</head>");  
    strHTMLBuilder.Append("<body>");  
    strHTMLBuilder.Append("<table border='1px' cellpadding='1' cellspacing='1' bgcolor='lightyellow' style='font-family:Garamond; font-size:smaller'>");  

    strHTMLBuilder.Append("<tr >");  
    foreach (DataColumn myColumn in dt.Columns)  
    {  
    strHTMLBuilder.Append("<td >");  
    strHTMLBuilder.Append(myColumn.ColumnName);  
    strHTMLBuilder.Append("</td>");  

    }  
    strHTMLBuilder.Append("</tr>");  


    foreach (DataRow myRow in dt.Rows)  
    {  

    strHTMLBuilder.Append("<tr >");  
    foreach (DataColumn myColumn in dt.Columns)  
    {  
    strHTMLBuilder.Append("<td >");  
    strHTMLBuilder.Append(myRow[myColumn.ColumnName].ToString());  
    strHTMLBuilder.Append("</td>");  

    }  
    strHTMLBuilder.Append("</tr>");  
    }  

    //Close tags.  
    strHTMLBuilder.Append("</table>");  
    strHTMLBuilder.Append("</body>");  
    strHTMLBuilder.Append("</html>");  

    string Htmltext = strHTMLBuilder.ToString();  

    return Htmltext;  
}

After this method, You can call this method and convert to html file as below

 string content = ExportDatatableToHtml((DataTable)Session["DataList"]);
 System.IO.File.WriteAllText(@"C:\sample.html", contents);

If my post helps to solve your question, kindly check the green tick and upward this answer

edited Apr 3, 2018 at 10:57

answered Apr 3, 2018 at 10:55

vivek ramasamy

11512 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

vivek ramasamy Over a year ago

You are assigning the dataset to the datalist1.datasource right. In that place, you can assign the dataset table in the session variable like in the my updated answer.

vivek ramasamy Over a year ago

Check and revert if need assistance. if solves your question , check the green tick :-)

Raniel Quirante Over a year ago

I got this error... when I put the Session["DataList"] below da.Fill(ds) 'System.Data.DataSet' does not contain a definition for 'tables' and no extension method 'tables' accepting a first argument of type 'System.Data.DataSet' could be found (are you missing a using directive or an assembly reference?)

vivek ramasamy Over a year ago

you check the condition like this if(ds != null) { If(ds.Tables.count > 0) { Session["DataList"] = ds.Tables[0]; } }

vivek ramasamy Over a year ago

tables - T should be in capital letter (Tables). I updated my previous answer

|

Collectives™ on Stack Overflow

Is it possible to StreamWrite the DataList Result to make an HTML file? (ASP.Net)

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related