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 = "ÒÔÏÂÊý¾ÝÊÇÉϸöÔÂ֮ǰµÄËùÓж©µ¥";
}
Ïà¹ØÎĵµ£º
ÕâÊÇҪʵÏֵŦÄÜ£º
µÚÒ»²½£ºÍÏÈëGridView¿Ø¼þ ²¢ÇÒÍê³É²éѯËùÓÐÊý¾ÝµÄ·½·¨ ͨ¹ýthis.GridView1.DataSource »ñÈ¡¼¯ºÏÊý¾Ý GridView1.DataBind() °ó¶¨Êý¾Ý
µÚ¶þ²½£ºÊµÏÖȫѡ¹¦ÄÜ
1. Ò³Ãæ´úÂ룺
´úÂë
<asp:TemplateField HeaderText="ȫѡ">
&nbs ......
±¾ÎĽ«Ì½ÌÖasp.netÏÂʵÏÖÎļþÉÏ´©½ø¶ÈÌõµÄ·½·¨¡£
Ò»°ãÇé¿öÏ£¬ÒªÊµÏÖÉÏ´«½ø¶ÈÌõÊ×ÏÈҪʵÏÖÉÏ´«Îļþ·Ö¿é¶ÁÈ¡£¬¶øÄ¬ÈÏÇé¿öÏ£¬iis½«Ö±½Ó°ÑÉÏ´«µÄÎļþÒ»´Î¶ÁÈëµ½ÄÚ´æÖУ¬ËùÒÔ±¾´¦µÄÄѵãÔÚÓÚÀ¹½ØiisµÄÎļþÉÏ´«¹ý³Ì£¬×ª¶ø×Ô¼ºµÄʵÏÖ·½Ê½¡£ËùÒÔ£¬ÎÒÃÇ¿ÉÒÔʵÏÖÒ»¸öIHttpModuleÀ´´¦ÀíÉÏ´«¹ý³Ì¡£¾ßÌåµÄ¹ý³ÌÊÇApplication_BeginReque ......
ǰ¼¸ÌìÎÒûÊÂÔÚͼÊé¹Ý½è±¾··ºÙºÙ£¬Í¦ÓÐÒâ˼µÄ£¬ÁíÍâÄÇÌìÔÚÌù°É¿´µ½µÄÒ»²ÅÅ®µÄÎÊÌâͻȻÏëµ½ÁË··¾Í¿´ÁË¿´£¬Í¦ÓÐÒâ˼µÄ¡£
¾ßÌå×ܽáµÄÄÚÈÝÎÒ½ñÌìд³öÀ´£¬¿ÏÄÜÓе㳤£¬µ«ÊǶÔÍøÕ¾¾ø¶ÔÓÐÓá£
Ò³ÃæµÄ´¦ÀíĬÈÏÇé¿öÏ£¬´¦ÀíASP¡£NETÒ³ÃæµÄÄ£Ðͱ¾ÖÊÉÏÊÇͬ²½µÄ¡£Õâ˵Ã÷£¬Ò³ÃæµÄÁ÷³ÌÊǹ̶¨µÄ£¬Ã¿Ò ......
Òì³£Ïêϸ£º
1. ´íÎóÁбíûÓмǼ£¬±àÒëͨ¹ý¡£
2. ÏÔʾÊä³ö:
“WebDev.WebServer.EXE”(ÍйÜ): ÒѼÓÔØ“C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll”£¬ÒÑÌø¹ý·ûºÅ¼ÓÔØ¡£ÒѶÔÄ£¿é½øÐÐÁËÓÅ»¯²¢ÆôÓÃÁ˵÷ÊÔÆ÷Ñ¡ÏöÎҵĴúÂ딡£
“WebDev.WebServer ......
½â¾ö·½·¨£º
1.¿´¿´ÄãµÄTerminal Services·þÎñÆô¶¯Ã»ÓУ¬Èç¹ûûÓÐÆô¶¯¾Í¿ÉÒÔ½â¾öÎÊÌâ¡£
2È·ÈÏ Machine Debug Manager ·þÎñÒÑÆô¶¯
3¡¢´ò¿ªÏîÄ¿ÊôÐÔ£¬ÔÚ“Debug”(µ÷ÊÔ)Ò»ÏîÀ°Ñ“Enable the Visual Studio hosting process”(ÆôÓÃVisual Studio ËÞÖ÷½ø³Ì)ǰµÄ¹³È¥µô¡£
4. ......