Datatable to HTML

[Alphonse Giambrone]

Is there a simple way to convert the contents of a datatable to an HTML
table.
I have a dataset containing multiple datatables that I need to be able to
insert all the data into an html email.
I could loop through the rows of each datatable, but thought there might be
a simpler method.

TIA
--

Alphonse Giambrone
Email: a-giam at customdatasolut ions dot us

[Steven Cheng[MSFT]]

Hi Alphonse,

I think if you want to get an Html table content from a given datatable,
generally we can consider either of the following means:
1. Since the System.Web.UI.W ebControls.Data Grid can be created on the fly
and render out its html content.
We may manually create a DataGrid instance (set AutoGenerateCol umns= true)
and bind the DataTable onto it , and call it's RenderControl method to
render into a HtmlTextWritter (created via a stringbuilder). After that , we
can get the datagrid's output html from the string builder. For example:

private void btnExport_Click (object sender, System.EventArg s e)
{
DataGrid dg = new DataGrid();
dg.AutoGenerate Columns = true;

dg.DataSource = GetDataTable();
dg.DataBind();

System.Text.Str ingBuilder sb = new System.Text.Str ingBuilder();
System.IO.Strin gWriter sw= new System.IO.Strin gWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter( sw);

dg.RenderContro l(htw);

divTable.InnerH tml = sb.ToString();

}

#sb.ToString() will return the htmltable content we want.

2. Put the DataTable into a DataSet and use the DataSet.GetXml method to
retreive the DataSet's xml representation. Then, use some custom xslt style
to transform the xml into html table content. This require us to provide an
xslt style sheet.

Hope these help. Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Alphonse Giambrone]

Thanks Steven,

I have already written the routine to loop through the datatables to get
what I need, but I will certainly try what you propose as it seems like it
might have more flexibility for future use.

--

Alphonse Giambrone
Email: a-giam at customdatasolut ions dot us
"Steven Cheng[MSFT]" <v-******@online.m icrosoft.com> wrote in message
news:XW******** ********@cpmsft ngxa10.phx.gbl. ..

Hi Alphonse,

I think if you want to get an Html table content from a given datatable,
generally we can consider either of the following means:
1. Since the System.Web.UI.W ebControls.Data Grid can be created on the fly
and render out its html content.
We may manually create a DataGrid instance (set AutoGenerateCol umns= true)
and bind the DataTable onto it , and call it's RenderControl method to
render into a HtmlTextWritter (created via a stringbuilder). After that , we can get the datagrid's output html from the string builder. For example:

private void btnExport_Click (object sender, System.EventArg s e)
{
DataGrid dg = new DataGrid();
dg.AutoGenerate Columns = true;

dg.DataSource = GetDataTable();
dg.DataBind();

System.Text.Str ingBuilder sb = new System.Text.Str ingBuilder();
System.IO.Strin gWriter sw= new System.IO.Strin gWriter(sb);
HtmlTextWriter htw = new HtmlTextWriter( sw);

dg.RenderContro l(htw);

divTable.InnerH tml = sb.ToString();

}

#sb.ToString() will return the htmltable content we want.

2. Put the DataTable into a DataSet and use the DataSet.GetXml method to
retreive the DataSet's xml representation. Then, use some custom xslt style to transform the xml into html table content. This require us to provide an xslt style sheet.

Hope these help. Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Steven Cheng[MSFT]]

Thanks for your followup Alphonse,

If you have any further questions later, please feel free to post here.
Good luck!
Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)