show all data in html table

MR alaa

10y964.NET

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("" + ds.Tables[0].Rows[i]["ID"] + "");

this gets me header what about data in rows

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

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger10y ago
Accepted 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("
");

//Building the Data rows.
foreach (DataRow row in dt.Rows)
{
html.Append("
");
foreach (DataColumn column in dt.Columns)
{
html.Append("
");
}
html.Append("
");
}

//Table end.
html.Append("
");
html.Append(column.ColumnName);
html.Append("
");
html.Append(row[column.ColumnName]);
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 = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.End();

Thanks & regards

JSB
Joginder Banger10y ago
hi ...thanks for reply for your valuable word.. If really help you then accept this answer
MR alaa10y ago
thank you so much for helping me