asp.netµ¼³öµ½excel
µ¼³öµ½excelµÄ·½·¨ÓжàÖÖ£¬±È½Ï³£¼ûµÄÊÇÖ±½Óµ¼³öµ½EXCEL,»¹ÓоÍÊÇÏȽ«Ò³ÃæµÄÊý¾Ýдµ½´ÅÅÌÎļþ£¬Ö®ºóÖ±½ÓÔÙ´ò¿ªÎļþ£¬ÁíÍ⻹ÓоÍ
ÊǽèÖúµÚÈý·½µÄ¿Ø¼þ¡£
ǰ¶Îʱ¼äдµÄµ¼³öÊý¾Ýµ½excelÔÚexcel2003ÖÐÕý³£¶øÔÚexcel2007ÖÐÊý¾ÝÂÒÂ룬½ñÌìÁ˽⵽ÔÀ´ÊÇResponse.ContentType = "application/ms-excel";µ¼Öµģ¬¸ÄΪResponse.ContentType = "application/vnd.ms-excel";Õý³£
public partial class Manager_ExportOrder : ShopOrderBase
{
#region ʼþ
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.btnSubmit.Visible = true;
this.btnDelete.Visible = false;
BindGridView();
//ÏÔʾÌáʾÐÅÏ¢
IList<WfmSysDictionaryItems> lst = GetChildOfFunPurview(Resources.Resource.safeMange);
if (lst != null || lst.Count > 0)
{
if (lst.Count == 1 && lst[0].SiName.Contains("Ò»¸öÔÂ"))
{
lblShow.Text = "ÒÔÏÂÊý¾ÝÊÇÉϸöÔÂ֮ǰµÄËùÓж©µ¥";
}
Ïà¹ØÎĵµ£º
Ä£°å»¯µÄÊý¾Ý°ó¶¨¿Ø¼þΪÎÒÃÇÔÚÒ³ÃæÉÏÏÔʾÊý¾ÝÌṩÁ˸ù±¾µÄÁé»îÐÔ¡£Äã¿ÉÄÜ»¹¼ÇµÃASP.NET v1.xÖеöÄ£°å»¯¿Ø¼þ£¨ÀýÈçDataListºÍRepeater¿Ø¼þ£©¡£ASP.NET 2.0ÈÔȻ֧³ÖÕâЩ¿Ø¼þ£¬µ«ÔÚÄ£°åÖаó¶¨Êý¾ÝµÄÓï·¨ÒѾ±»¼ò»¯ºÍ¸ÄÉÆÁË¡£±¾ÎĽ«ÌÖÂÛÔÚÊý¾Ý°ó¶¨¿Ø¼þÄ£°åÖаó¶¨Êý¾ÝµÄ¶àÖÖ·½·¨¡£
Êý¾Ý°ó¶¨±í´ïʽ
ASP.NET 2.0¸ÄÉÆÁËÄ£°åÖÐ ......
//ÒÔÏ´úÂë¸ù¾Ý±ðÈËÎÄÕºÍ×Ô¼ºÕûÀí
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
namespace WebApplication1
{
public partial class DownfFile : System.Web.UI.Page
{
p ......
1¡¢½¨Á¢Êý¾Ý²ã Á¬½ÓÊý¾Ý¿â->½¨Á¢Êý¾Ý¼¯*.xsd->±íÖн¨Á¢²éѯ·½·¨
2¡¢½¨Á¢ÒµÎñÂß¼²ã °ü×°TableAdapter·½·¨³ÉÀà
3¡¢½¨Á¢Ä¸°åÒ³ºÍÕ¾µãµ¼º½£¨ CSS´ýѧϰ£©
4¡¢Ê¹ÓÃÊý¾ÝÔ´Õ¹ÏÖÊý¾Ý ÎåÖÖÊý¾ÝÔ´ ±à¼Êý¾ÝÔ´²ÎÊý ʹÓÃtableadapter·½·¨
5¡¢Ê¹ÓÃdropDownList¹ýÂËÖ÷-´Ó±¨±í
ʹÓÃtableadapter·½·¨ ......
Óö¼û¹ýÕâÑùµÄÎÊÌ⣬ºÜÆæ¹Ö£¬¾ÍÊÇ asp.net button°´Å¥onclickʼþ´¥·¢²»ÁË£¬
µã»÷û·´Ó¦£¬È»ºóÔÚÍøÉϲéÁËЩ×ÊÁÏ£¬·¢ÏÖÒ»¸ö˵·¨£¬“Ò»°ãÀ´ËµÊǿͻ§¶ËÔ´´úÂëÖÐÓжà¸öform±êʶ£¬»á³öÏÖÕâÖÖÇé¿ö”
ÓÚÊǾͲ鿴×Ô¼ºµÄÒ³Ãæ´úÂë£¬ÕæµÄÓÐÁ½¸öform£¬È¥µôÒ»¸öºó£¬¾ÍÕý³£À²£¬
ÖÁÓÚ ÕâÖÖÇé¿ö£¬Ôڴ˼ÇÏÂÀ´£¬×÷¸öѧϰµÄÒ»¸öÐ¡Ö ......
ÔÚASP.NET 1.1ÖУ¬Òª×ö1¸öµ¯³öµÄÈ·È϶Ի°¿òµÄ»°£¬Ò»°ãÊÇÔÚ·þÎñ¶ËµÄ´úÂëÖÐÕâÑùд£º
private void Page_Load(object sender, System.EventArgs e)
{
btnClick.Attributes.Add("onclick", "return confirm('Are you sure?');");
// Button1.Attributes["OnClick"] = "return conf ......