摘要：#region 导出Excel方法 //导出到Excel按钮 protected void btnExport_Click(object sender, EventArgs e) { Export("application/ms-excel", "字段数据.xls"); } private void Export(string FileType, string FileName) { //清楚分页 gridView.AllowPag... 阅读全文

摘要：#region //'Revision: 1.00 Created Date: 2013/08/02 Created ID: Una [#1300071]增加多選框 /// /// Session獲取多選框值 /// private void RememberOldValues() { ArrayList categoryIDList = new ArrayList(); string index = ""; foreach (GridViewRow ro... 阅读全文

摘要：/// /// 根據gridview導出excel /// /// public void DGToExcel(System.Web.UI.Control ctl) { HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=Excel.xls"); HttpContext.Current.Response.Charset = "UTF-8"; ... 阅读全文

摘要：是指模拟IIS身份验证 導入錯誤時可刪除protected void btnImport_Click(object sender, EventArgs e) { if (FileUpload1.HasFile == false)//HasFile用来检查FileUpload是否有指定文件 { Response.Write(" "); return;//当无文件时,返回 } string IsXls = System.IO.Path.GetExtension(FileUpload1.Fi... 阅读全文

摘要：Create TRIGGER [dbo].[trigInstructionsDelete]ON dbo.Instructions instead OF DELETEAS BEGIN DECLARE @InsId INT SELECT @InsId=InstructionsID FROM deleted --删除 DELETE dbo.Transfer WHERE InstructionsID=@InsId DELETE dbo.Instructions WHERE InstructionsID=@InsIdEND 阅读全文