Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

asp.netµ¼³öExcel/Csv¸ñʽÊý¾Ý×îÓÅ·½°¸£¨C#£©

[ת]asp.netµ¼³öExcel/Csv¸ñʽÊý¾Ý×îÓÅ·½°¸£¨C#£©
±¾ÎÄת×Ô£ºhttp://www.cnblogs.com/lovenets2008/archive/2008/05/06/1184234.html
Ô­ÎÄÈçÏ£º
 
ºÃ¾ÃûÓÐдµãʲôÁË£¬Ò²ÐíÊÇ̫æ¡£Ò»ÄêÁË£¬»ýÀÛÁ˲»ÉٺõĶ«¶«£¬Óлú»áʱ¾Íд³öÀ´Óë´ó¼Ò·ÖÏí¡£
ºÃ£¬ÑÔ¹éÕý´«¡£
µ¼³öµ½Excel/CscÎļþ²¢²»ÄÑ£¬ËùÒÔ¾ÍÓкö෽·¨£º¿Ø¼þÖ±½ÓRender¡¢°ÑDataSetÊä³ö³ÉStringÔÙWrite³öÀ´µÈ£¬£¨µ±È»Èç¹ûµ÷ÓÃExcel³ÌÐòµÄ¿âÎļþµÄ»°»¹¿ÉÒÔʹÓøüÇ¿µÄÖ±½Ó²Ù×÷ExcelµÄ·½·¨£¬µ«ÕâÖÖ·½·¨ÓÃÓÚWeb·þÎñÏÔµÃÓеãÒªÇóÌ«¸ß£º±ØÐëÈÃWeb·þÎñÆ÷°²×°Ö¸¶¨°æ±¾µÄExcel»òÆäÖ§³Ö¿âÎļþ£©¡£¾ÍÆäǰÁ½ÖÖ·½·¨£¬Êµ¼ÊÉÏÒ²ÊÇÒ»ÑùµÄ£¬RenderÒ²ÊǰÑÓÉDataSetת±äµÄViewÉú³ÉΪһ¸öTableÊä³öµ½¿Í»§¶Ë¶øÒÑ£¬Ö»²»¹ýÒþ²ØÁËϸ½Ú£¬Èç¹û²»ÐÅ£¬ÄãÓÃEditPlusʲôµÄ¿´¿´Éú³ÉµÄ.xlsÎļþ¾ÍÖªµÀÁË¡£
ExcelµÄʶ±ðÁ¦Ì«Ç¿ÁË£¬ÒÔÖÁÓÚËü±¾ÉíµÄ¸ñʽ¡¢Csv¸ñʽ¡¢Tab·Ö¸ô·û¸ñʽ¡¢ÍøÒ³µÄTable¸ñʽµÈ¶¼Äܹ»ºÜºÃµÄ´ò¿ª¡£µ«ÊÇËü“Ì«´ÏÃ÷”ÁË£¬ÒÔÖÁÓÚ×Ô¶¯Ê¶±ðÊý×ÖºÍ×Ö·û´®£¬¶øÇÒÒª°Ñ³¬¹ý11λµÄÊý×Ö×Ô¶¯±äΪ¿ÆÑ§¼ÆÊý·¨µÄ¸ñʽ£¬ÄãÊÔÊÔÊäÈë“123456789012”£¬À뿪ÄǸöµ¥Ôª¸ñ£¬¾Í³É“123457E+11”ÁË£¬¹»´ÏÃ÷µÄ°É£¬²»¹ýÓÐʱ»áÈÃÎÒÃǸоõ²»±ã£¬ÒòΪÎÒÊäÈëµÄ¾ÍÊÇÎÒ×Ô¼ºµÄÉí·ÝÖ¤ºÅÂ룬β°ÍÉÏûÓГX”£¬±¾À´ºÃºÃµÄ15λÊý×Ö£¬µÃÏÖÔÚ³ÉÕâô¸ö¼ÆÊý·¨ÁË¡£ÄÇÎҾ͸ĸÄÏÔʾ¸ñʽ°É£¬¸ÄΪ°ÑÊý×ÖÏÔʾΪÎı¾£¬ºÃÁË¡£¿ÉÊǹú¼ÒµÄÉí·ÝÖ¤Éý¼¶ÁË£¬ºÅÂë±ä³É18룬ÎÒ°ÑËüÊäÈëµ½Êý¾Ý¿â£¬µ¼³öÀ´Ê±£¬Óøղŵķ½·¨´¦Àí¹ý£¬18λû´í£¬¿ÉÊÇ×îºóÈýλÔõô¶¼ÊÇÁãÁË£¡ExcelΪÎÒÃÇ×öÁËÌ«¶àµÄÊ£¬²»¹ÜÊÇÓ¦¸ÃµÄ»¹ÊDz»Ó¦¸ÃµÄ¡£
Ôõô½â¾ö£¿Çë¿´´úÂ룺
    public static string ExportTable(DataSet ds)
    {
        string data = "";
        //data = ds.DataSetName + "\n";
        foreach (DataTable tb in ds.Tables)
        {
            //data += tb.TableName + "\n";
            data += "<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">";
  &nb


Ïà¹ØÎĵµ£º

ASP.NET


      ¿ÉÒÔʹÓà SqlDataSource ¿Ø¼þÐÞ¸ÄÊý¾Ý¿âÖеÄÊý¾Ý¡£Ê¹Óøüз½°¸ÖÐµÄ SqlDataSource ¿Ø¼þµÄ×î³£Ó÷½·¨ÊǼìË÷Êý¾Ý²¢Ê¹ÓÃÊý¾Ý°ó¶¨ Web ·þÎñÆ÷¿Ø¼þ£¨Èç GridView¡¢DetailsView »ò FormView ¿Ø¼þ£©ÏÔʾÊý¾Ý¡£¿ÉÒÔÅäÖÃÊý¾Ý°ó¶¨¿Ø¼þºÍ SqlDataSource ÒÔ¸üÐÂÊý¾Ý¡£´ó¶àÊýÊý¾Ý°ó¶¨¿Ø¼þ¶¼ÔÊÐíÄú½«Æä ......

Asp.net ºǫ́µ÷ÓÃjs·½·¨(ת)

1. ÓÃResponse.Write·½·¨
¡¡¡¡´úÂëÈçÏ£º
Response.Write("<script type='text/javascript'>alert("XXX");</script>");
´Ë·½·¨È±ÏݾÍÊDz»Äܵ÷Óýű¾ÎļþÖеÄ×Ô¶¨ÒåµÄº¯Êý£¬Ö»Äܵ÷ÓÃÄÚ²¿º¯Êý£¬¾ßÌåµ÷ÓÃ×Ô¶¨ÒåµÄº¯ÊýÖ»ÄÜÔÚResponse.WriteдÉϺ¯Êý¶¨ Ò壬±ÈÈç
Response.Write("<script type='tex ......

ASP.NET µÝ¹é °ó¶¨TreeView

 Ê×ÏÈ¿´Êý¾Ý¿â±í½á¹¹£º
´úÂëÈçÏ£º
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.Htm ......

ASP.NETÖеĿØÖÆÌ¨Êä³ö

 ÒÔǰ×ö.NET winformµÄʱºò£¬Ò»Ö±¶¼ÊÇÓà Console.WriteÏò¿ØÖÆÌ¨Êä³öÐÅÏ¢µÄ£¬Õâ´Î×öwebµÄʱºò£¬·¢ÏÖÕâ¸öÓï¾äÓò»ÁË¡£
²éÁËÒ»ÏÂ×ÊÁÏ£¬²Å·¢ÏÖweb³ÌÐòÖ´ÐÐʱ£¬ÊDZ»¸½¼Óµ½IIS½ø³ÌµÄÒ»¸öµ¥¶ÀµÄAppDomainÖеģ¬ËùÒÔ¾ÍËãÓÐÊä³öÒ²¿´µ½£¬ËùÒÔConsole.Writeµ÷ÊÔÐÅÏ¢ÎÞ·¨ÏÔʾ³öÀ´¡£
ÄÇô½â¾ö°ì·¨ÊÇ£¬ÓÃdebug´úÌæ£º
System.Diagn ......

asp.net(vs2005)ʹÓÃupdatepanel¿Ø¼þÏê½â

  ×î½ü×öÒ»¸öÍøÕ¾£¬ÀïÃæÉæ¼°µ½¼¶ÁªµÄÎÊÌ⣨ÈçÊ¡-ÊУ¬Æ·ÅÆ-ÐͺŵÈ), ÎÒÓõÄÊÇDropDownListÀ´ÊµÏֵģ¬ÉèÖø¸¼¶µÄAutoPostBackÊôÐÔÎªÕæ.È»ºóÔÚËüµÄSelectedIndexChanged()ʼþÀïдÏàÓ¦µÄ´úÂ룬ÕâÑù¾ÍÄÜʵÏÖ¼¶Áª¹ØÏµ£¨µ±È»ÕâÀïҪעÒâIsPostBackµÄÎÊÌ⣩.  ×öºÃÖ®ºóÓÃʱ·¢ÏÖÒ»¸ö·Ç³£²»Ë¬µÄÎÊÌ⣬ÄǾÍÊÇÿ´Î¶¼»áˢУ¬Õ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ