โค้ด: เลือกทั้งหมด
using System.Text;
protected void imgExportToExcel_Click(object sender, ImageClickEventArgs e)
{
DataTable dtlocal = null; // DataTable dtlocal = ds.Tables[0];
if (Session["fdt"] != null)
dtlocal = (DataTable)Session["fdt"];
if (dtlocal != null)
{
if (dtlocal.Rows.Count > 0)
{
string attachment = "attachment; filename=[color=#FF0000]YourFileName.xls[/color]";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentEncoding = Encoding.Default;
Response.ContentType = "application/vnd.ms-excel";
string tab = "";
foreach (DataColumn dc in dtlocal.Columns)
{
Response.Write(tab + dc.ColumnName);
tab = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dtlocal.Rows)
{
tab = "";
for (i = 0; i < dtlocal.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.End();
}
}
}