之前做过一个这样的项目,需要把Girdiew查找出来的数据导出为Excel文件和Word文件,现在先收集起来。当初录入的是同学的名字,来个高斯模糊先~
//导出excel
protected void btnExcel_Click(object sender, EventArgs e)
{
GridView1.AllowPaging = false;
string strsql = @"SELECT class.class_name, users.user_name, COUNT(late.user_id) AS cishu FROM class INNER JOIN
users ON class.class_id = users.class_id INNER JOIN
late ON users.user_id = late.user_id";
if (dept.SelectedValue != "")
{
strsql += " and users.dept_id=" + dept.SelectedValue;
}
if (special.SelectedValue != "")
{
strsql += " and users.spc_id=" + special.SelectedValue;
}
if (room.SelectedValue != "")
{
strsql += " and users.class_id=" + room.SelectedValue;
}
if (region.SelectedValue != "")
{
strsql