show all data in html table

Question

hi every body

i have a page that i need to show searched data in it my database is excel suppose i don't know how many columns and rows i need to show all data in a table depend on number of columns if there is one column in excel sheet it drew a table with on columns um if they are column i excel sheet it draw 10 columns in page and so on the header of the table should be the same in excel

how can it be done in asp.net c# ?

use something like that but i need to know how to appened data to html
foreach (DataColumn column in ds.Tables[0].Columns)
{

lblresult.Text = column.ColumnName;
}

to be like that
html.Append("<td>" + ds.Tables[0].Rows[i]["ID"] + "</td>");

this gets me header what about data in rows

foreach (DataRow row in ds.Tables[0].Rows)
{

lblresult.Text = ??? to get values;
}

Joginder Banger · Answer

Hi MR ALAA I hope every thing well and good. kindly this below code it's might be very useful for you. if (! this .IsPostBack) { //Populating a DataTable from database. DataTable dt = this .GetData(); //Building an HTML string. StringBuilder html = new StringBuilder (); //Table start. html.Append(   ); //Building the Header row. html.Append(   ); foreach ( DataColumn column in dt.Columns) { html.Append(   ); html.Append(column.ColumnName); html.Append(   ); } html.Append(   ); //Building the Data rows. foreach ( DataRow row in dt.Rows) { html.Append(   ); foreach ( DataColumn column in dt.Columns) { html.Append(   ); html.Append(row[column.ColumnName]); html.Append(   ); } html.Append(   ); } //Table end. html.Append(   ); //Append the HTML string to Placeholder. PlaceHolder1.Controls.Add( new Literal { Text = html.ToString() }); } If you want create a dynamic table must be used this code dt = city.GetAllCity();//your datatable string attachment = attachment; filename=city.xls; Response.ClearContent(); Response.AddHeader(content-disposition attachment); Response.ContentType = application/vnd.ms-excel; string tab = ; foreach (DataColumn dc in dt.Columns) { Response.Write(tab + dc.ColumnName); tab = 	; } Response.Write(
); int i; foreach (DataRow dr in dt.Rows) { tab = ; for (i = 0; i { Response.Write(tab + dr[i].ToString()); tab = 	; } Response.Write(
); } Response.End(); Thanks & regards JSB

Joginder Banger · Answer

hi ...thanks for reply for your valuable word.. If really help you then accept this answer

MR alaa · Answer

thank you so much for helping me