DataTable ds = (DataTable)Session["SearchReslutData"];
if (ds == null)
{
DataNull.Text = "没有数据将要保存!";
return;
}
try
{
StringBuilder sb = new StringBuilder();
//在Excel文件里面显示的[对应数据库里面的字段]
sb.AppendLine("姓名:\t" + "部门:\t"+ "角色:\t"+ "操作类型:\t"+ "操作时间:\t"+ "操作对象:\t");
foreach (DataRow dr in ds.Rows)
{
sb.Append(dr.ItemArray[0].ToString() + "\t");
sb.Append(dr.ItemArray[1].ToString() + "\t");
sb.Append(dr.ItemArray[2].ToString() + "\t");
sb.Append(dr.ItemArray[3].ToString() + "\t");
sb.Append(dr.ItemArray[4].ToString() + "\t");
sb.Append(dr.ItemArray[5].ToString() + "\t\r\n");
}
string bbdl = DateTime.Now.ToString("yyyyMMdd-HHmmss");
HttpResponse hr = Page.Response;
hr.ContentEncoding = Encoding.GetEncoding("GBK");
//filename="output.xls"我这里写死了的,就是Excel里面Sheet1名字
hr.AppendHeader("Content-Disposition", "attachment;filename=" + bbdl + ".xls");
//这里设置输出的类型
hr.ContentType = "application/ms-excel";
hr.Write(sb.ToString());
hr.Flush();
hr.End();
DataNull.Text = "保存成功!";
}
catch (Exception)
{
DataNull.Text = "文件出错,请重新导出!";
}
if (ds == null)
{
DataNull.Text = "没有数据将要保存!";
return;
}
try
{
StringBuilder sb = new StringBuilder();
//在Excel文件里面显示的[对应数据库里面的字段]
sb.AppendLine("姓名:\t" + "部门:\t"+ "角色:\t"+ "操作类型:\t"+ "操作时间:\t"+ "操作对象:\t");
foreach (DataRow dr in ds.Rows)
{
sb.Append(dr.ItemArray[0].ToString() + "\t");
sb.Append(dr.ItemArray[1].ToString() + "\t");
sb.Append(dr.ItemArray[2].ToString() + "\t");
sb.Append(dr.ItemArray[3].ToString() + "\t");
sb.Append(dr.ItemArray[4].ToString() + "\t");
sb.Append(dr.ItemArray[5].ToString() + "\t\r\n");
}
string bbdl = DateTime.Now.ToString("yyyyMMdd-HHmmss");
HttpResponse hr = Page.Response;
hr.ContentEncoding = Encoding.GetEncoding("GBK");
//filename="output.xls"我这里写死了的,就是Excel里面Sheet1名字
hr.AppendHeader("Content-Disposition", "attachment;filename=" + bbdl + ".xls");
//这里设置输出的类型
hr.ContentType = "application/ms-excel";
hr.Write(sb.ToString());
hr.Flush();
hr.End();
DataNull.Text = "保存成功!";
}
catch (Exception)
{
DataNull.Text = "文件出错,请重新导出!";
}