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
Ïà¹ØÎĵµ£º
ͨ³££¬SQL Óï¾äºÍ´æ´¢¹ý³Ì°üÀ¨ÔËÐÐʱ¼ÆËãµÄ²ÎÊý¡£Ê¹ÓòÎÊý±àдµÄ SQL Óï¾ä³Æ×÷²ÎÊý»¯ SQL Óï¾ä¡£
ʹÓà SqlDataSource ¿Ø¼þʱ£¬¿ÉÒÔÖ¸¶¨Ê¹ÓòÎÊýµÄ SQL ²éѯºÍÓï¾ä¡£Í¨¹ý¸ù¾ÝÔËÐÐʱ¼ÆËãµÄÖµ¶ÁдÊý¾Ý¿âÐÅÏ¢£¬ÕâÓÐÖúÓÚÌáÉýÊý¾Ý°ó¶¨»·¾³µÄÁé»îÐÔ¡£¿ÉÒÔ´Ó¸÷ÖÖÔ´»ñÈ¡²ÎÊýÖµ¡£ÕâЩԴ°üÀ¨ ASP.N ......
Ò»°ã´î½¨Èý²ã¿ò¼ÜÏîÄ¿ÊÇÕâÑùµÄ:
1¡¢´´½¨Ò»¸ö¿ÕµÄ½â¾ö·½°¸
2¡¢´´½¨Àà¿âÏîÄ¿
3¡¢´´½¨ÍøÕ¾ÏîÄ¿
4¡¢Ìí¼ÓÏîĿ֮¼äµÄÒýÓã¬ÐèҪעÒâµÄÊDZíʾ²ã£¨ÍøÕ¾ÏîÄ¿²ã£©ÊDz»ÐèÒªÌí¼ÓÆäËü²ãÒýÓõģ¬ÒòΪÔËÐк󣬻á×Ô¶¯²úÉú¶ÔÆäËüÏîÄ¿µÄÒýÓÃ
Èý²ã½á¹¹£º
Êý¾Ý·ÃÎʲ㣺Ö÷ҪʵÏÖÊý ......
////½ñÌìÔÚÐ޸ijÌÐòµÄʱºò·¢ÏÖÒ»¸öСµÄÎÊÌâÌØ¼Ç¼ÈçÏÂ:
//////ÓÐʱºòdatetimeÎÞ·¨×ª³Éstring£¬¿ÉÒÔÓÃgetdate()Ö±½Ó²åÈë¾Í¿ÉÒÔÁË
string str = "update adaddress set shenhe=" + ck + " ,shentime=getDate() where id=" + uid + "";
/////////////////////////////////////////
ÒÔϾßÌå½éÉÜÈÕÆÚÔõÑùת»»
DateTime.Now ......
Ê×ÏÈ¿´Êý¾Ý¿â±í½á¹¹£º
´úÂëÈçÏ£º
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 »ñµÃ¿Í»§¶ËµÄIP£¬×î³£¼ûµÄÊÇʹÓÃÏÂÊö´úÂ룺
string user_IP = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
¶ÔÓÚÁ˽â´úÀí·þÎñÆ÷Çé¿öµÄÈË£¬ÎÒÃÇ»áÖªµÀ£¬Èç¹ûÓû§Ê¹ÓÃÁË´úÀí·þÎñÆ÷£¬ÉÏÊö´úÂë»ñµÃµÄÊÇ´úÀí·þÎñÆ÷µÄIPµØÖ·£»Èç¹ûÓû§Ê¹ÓÃÁ˶à¸ö´úÀí·þÎñÆ÷£¬ÔòÊǵ½´ï·þÎñÆ÷µÄ×îºóÒ»¸ö´úÀí· ......