public static DataSet Query(string SQLString) { using (SqlConnection connection = new SqlConnection(ConnectionString)) { DataSet ds = new DataSet(); try { connection.Open(); SqlDataAdapter command = new SqlDataAdapter(SQLString, connection); command.Fill(ds, "ds"); } catch (System.Data.SqlClient.SqlException ex) { throw new Exception(ex.Message); } return ds; } }
上面代码为执行SQL语句,反回dataset类型出来
DataSet ds = Pagin.Query(strsql);
public void EasyExportExcel(HttpResponse resp) { resp.Charset = "gb2312"; resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); resp.AppendHeader("Content-Disposition", "attachment;filename=" + FileName + ".xls"); resp.ContentType = "applicationnd.ms-excel"; string herd = "<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=GB2312\"/>"; StringBuilder table = new StringBuilder(); table.Append("<table border='1'>"); #region 设置表头 table.Append("<tr>"); for (int i = 0; i < this.Data.Columns.Count; i++) { table.Append("<th>" + this.Data.Columns[i].ColumnName + "</th>"); } table.Append("</tr>"); #endregion table.Append("</table>"); resp.Write(herd + table); resp.Flush(); resp.End(); }
export.EasyExportExcel(this.Response);
即可导出 EXCEL
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步