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 = "ÒÔÏÂÊý¾ÝÊÇÉϸöÔÂ֮ǰµÄËùÓж©µ¥";
}
Ïà¹ØÎĵµ£º
ÒòΪ¸Õ¸Õ½Ó´¥C#ÓïÑÔ²»¾Ã,ÓÚÊÇÎÒ°Ñ¿ØÖÆÌ¨¸øÈÓÁË,ÒòΪÎÒÌÖÑá¿ØÖÆÌ¨!
¶øÊÂʵÉÏÎÒÖ»¶ÔWinForm¼¼Êõ¸ÐÐËȤ,µ«ÊÂʵÉϵ½ÏÖÔÚÎÒ·¢ÏÖASP.Net C#µÄWeb¼¼ÊõÊÇÈÕÏÔÖØÒªÆðÀ´!
ÓÚÊÇ¿ªÊ¼½Ó´¥,¸Õ¸ÕÆð²½ÓÚËùÖª,ÓÈÆäÊÇһЩ×î¼òµ¥µÄ¶«Î÷,µ½ÍøÉÏËÑË÷Á˺ܾÃ,²»ÊÇÌ«ÂÒ¾ÍÊÇ˵²»Çå³þ!
¾Ù¸öÀý×ÓÀ´Ëµ,¾Í˵SessionºÃÁË,²»ÖªµÀÍøÉϵÄÄÇЩ¼Ò»ïµ½µ×ÔÚ½²Ê ......
Ä£°å»¯µÄÊý¾Ý°ó¶¨¿Ø¼þΪÎÒÃÇÔÚÒ³ÃæÉÏÏÔʾÊý¾ÝÌṩÁ˸ù±¾µÄÁé»îÐÔ¡£Äã¿ÉÄÜ»¹¼ÇµÃASP.NET v1.xÖеöÄ£°å»¯¿Ø¼þ£¨ÀýÈçDataListºÍRepeater¿Ø¼þ£©¡£ASP.NET 2.0ÈÔȻ֧³ÖÕâЩ¿Ø¼þ£¬µ«ÔÚÄ£°åÖаó¶¨Êý¾ÝµÄÓï·¨ÒѾ±»¼ò»¯ºÍ¸ÄÉÆÁË¡£±¾ÎĽ«ÌÖÂÛÔÚÊý¾Ý°ó¶¨¿Ø¼þÄ£°åÖаó¶¨Êý¾ÝµÄ¶àÖÖ·½·¨¡£
Êý¾Ý°ó¶¨±í´ïʽ
ASP.NET 2.0¸ÄÉÆÁËÄ£°åÖÐ ......
½ñÌìÔÚÓÃDataListµÄÄ£°åÁеÄʱºòϰ¹ßÐÔµØÏñÔÚ03ÖÐÄÇÑùÈ¥¸øÄ£°åÁеİó¶¨×ֶμӸö´¦Àíº¯Êý£º
< asp:Label ID = " Label1 " runat = " server " Text = ' <%#ConvertState(Bind("Status"))%> ' ></ asp:Label >
¿ÉÊǾ¹È»³ö´í£ºµ±Ç°ÉÏÏÂÎÄÖв»´æÔÚÃû³Æ“Bind” ......
Òì³£Ïêϸ£º
1. ´íÎóÁбíûÓмǼ£¬±àÒëͨ¹ý¡£
2. ÏÔʾÊä³ö:
“WebDev.WebServer.EXE”(ÍйÜ): ÒѼÓÔØ“C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll”£¬ÒÑÌø¹ý·ûºÅ¼ÓÔØ¡£ÒѶÔÄ£¿é½øÐÐÁËÓÅ»¯²¢ÆôÓÃÁ˵÷ÊÔÆ÷Ñ¡ÏöÎҵĴúÂ딡£
“WebDev.WebServer ......
1¡¢½¨Á¢Êý¾Ý²ã Á¬½ÓÊý¾Ý¿â->½¨Á¢Êý¾Ý¼¯*.xsd->±íÖн¨Á¢²éѯ·½·¨
2¡¢½¨Á¢ÒµÎñÂß¼²ã °ü×°TableAdapter·½·¨³ÉÀà
3¡¢½¨Á¢Ä¸°åÒ³ºÍÕ¾µãµ¼º½£¨ CSS´ýѧϰ£©
4¡¢Ê¹ÓÃÊý¾ÝÔ´Õ¹ÏÖÊý¾Ý ÎåÖÖÊý¾ÝÔ´ ±à¼Êý¾ÝÔ´²ÎÊý ʹÓÃtableadapter·½·¨
5¡¢Ê¹ÓÃdropDownList¹ýÂËÖ÷-´Ó±¨±í
ʹÓÃtableadapter·½·¨ ......