62,046
社区成员
发帖
与我相关
我的任务
分享
StringBuilder sb = new StringBuilder();
foreach (RepeaterItem re in Re_Article_Tbl.Items)
{
CheckBox cb = re.FindControl("Ch_Id") as CheckBox;
if (cb.Checked)
{
int id = Convert.ToInt32(cb.Text);
using (SqlDataReader dr = Common.SqlHelper.ExecuteReader(Common.SqlHelper.ConnectionString, CommandType.Text, "select ID,TName,Title from New n inner join New_T t on n.CID=t.TID where ID=" + id + ""))
{
while (dr.Read())
{
sb.Append("<table style=\"border:1px solid #ccc;\" cellpadding=\"0\" cellspacing=\"0\">");
sb.Append("<tr><td>ID:</td><td>" + dr.GetInt32(0).ToString() + "</td></tr>");
sb.Append("<tr><td>分类名称:</td><td>" + dr.GetString(1).ToString() + "</td></tr>");
sb.Append("<tr><td>文章标题:</td><td>" + dr.GetString(2).ToString() + "</td></tr>");
sb.Append("</table>");
sb.Append("<br/>");
sb.Append("<br/>");
}
}
}
}
Response.Clear();
Response.Buffer = false;
Response.Charset = "utf8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("content-disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMdd HHmmss") + ".doc");
Response.ContentType = "application/ms-word";
StringWriter sw = new StringWriter(sb);
HtmlTextWriter hw = new HtmlTextWriter(sw);
Response.Write(sw.ToString());
Response.Flush();
Response.Close();
Response.End();