asp.net²Ù×÷word
http://www.cnblogs.com/jinglelin/archive/2005/09/02/228486.html
Éæ¼°µ½asp.net²Ù×÷wordµÄÎÊÌâ
½ñÄêÂ½ÐøÓÖÅöµ½²Ù×÷excel¡¢wordµÈofficeÎĵµ
ʹÓõͼÊÇInteropÏà¹Ødll£¬´ò¿ªofficeÏà¹Ø½ø³Ì½øÐвÙ×÷
ΪÃâÍü¼Ç£¬½«Ïà¹ØtipÕûÀíÈçÏ£º
1. ÒýÓÃÎļþ,¼¸¸ödll´ò°üÁË
2. ²Ù×÷word´úÂëʾÀý:
using ImportExportToOffice;
using Microsoft.ApplicationBlocks.Data;
protected void btnJianJie_Click(object sender, EventArgs e)
{
string sYear = DropDownList2.SelectedValue;
string sMonth = DropDownList1.SelectedValue;
string sDate1 = String.Format("{0}-{1}-{2}", sYear, sMonth, "1");
string sDate2 = String.Format("{0}-{1}-{2}", sYear, sMonth, System.DateTime.DaysInMonth(int.Parse(sYear), int.Parse(sMonth)).ToString());
word = new ImportExportToWord();
string sTmpUrl = "../Report/" + Guid.NewGuid().ToString() + ".Doc";
string sTmpFile = Server.MapPath(sTmpUrl);
string sModelDoc = Server.MapPath("../Report/¹ú¼ÊÂþÓμò±¨Ä£°å.doc");
System.IO.File.Copy(sModelDoc, sTmpFile, true);
try
{
word.Open(sTmpFile);
object sBookMark = "";
//GSM À´·Ãǰʮ ·Ö¹«Ë¾
sBookMark = "GSM_1";
if (word.Document.Bookmarks.Exists(sBookMark.ToString()))
{
word.Document.Bookmarks.get_Item(ref sBookMark).Select();
string sSql = "SELECT TOP 10 t1.ToCarrier, COUNT(t1.ToCarrier) AS Num, t2.ShortName AS Name" +
" from BiteGSM t1 INNER JOIN" +
" BranchInfo t2 ON t1.ToCarrier = t2.ID" +
" INNER JOIN DispatchInfo t3 ON t1.DispatchID = t3.ID" +
" Where t3.SendTime >='" + sDate1 + "'" +
" And t3.SendTime <='" + sDate2 + "'" +
" And t1.SimType=1" +
" GROUP BY t1.ToCarrier, t2.ShortName" +
" ORDER BY COUNT(t1.ToCarrier) DESC";
SqlDa
Ïà¹ØÎĵµ£º
1.ASP.NETÔËÐÐÔÀí¸ÅÊö
¡¡¡¡ÈçÉÏͼ£¬µ±Ò»¸öhttpÇëÇó·¢Ë͹ýÀ´²¢±»IIS»úÊÕµ½Ö®ºó,IISÊ×ÏÈͨ¹ýÄãÇëÇóµÄÒ³ÃæÀàÐÍΪÆä¼ÓÔØÏàÓ¦µÄdllÎļþ£¬È»ºóÔÚ´¦Àí¹ý³ÌÖн«ÕâÌõÇëÇó·¢Ë͸øÄܹ»´¦ÀíÕâÌõÇëÇóµÄÄ£¿é,¶øÔÚASP.NETÖÐÕâ¸öÄ£¿é¾Í½Ð×öHttpHandler,ΪʲôaspxÕâÑùµÄÎļþ¿ÉÒÔ±»·þÎñÆ÷´¦Àí,ÄÇÊÇÒòΪÔÚ·þÎñÆ÷¶ËÓÐĬÈϵÄHttpHandlerרÃÅ´ ......
1.ʲôÊÇcookie?
cookie ÊÇһС¶ÎÎı¾ÐÅÏ¢£¬°éËæÓû§ÇëÇó£¬ÔÚweb·þÎñÆ÷ºÍä¯ÀÀÆ÷Ö®¼ä´«µÝ¡£Óû§Ã¿´Î·ÃÎÊÕ¾µãµÄʱºò£¬
webÓ¦ÓóÌÐò¶¼¿ÉÒÔ¶ÁÈ¡cookie°üº¬µÄÐÅÏ¢¡£
¼ÙÉèÔÚÓû§ÇëÇóÄúµÄÍøÕ¾µÄij¸öÒ³ÃæÊ±£¬ÄúµÄÓ¦ÓóÌÐò²»½öÊÇ·µ»ØÇëÇóµÄÒ³Ãæ¡£Í¬Ê±Ò²·µ»ØÒ»¸ö°üº¬ÈÕÆÚ
ºÍʱ¼äµÄcookie¡£Óû§µÄä¯ÀÀÆ÷ÔÚ»ñµÃÒ³ÃæµÄͬʱҲ»ñµÃÁË ......
ASP.NETÒ³ÉúÃüÖÜÆÚµÄ¶¨Ò壬ÓÐÒÔÏÂ8¸ö·½Ã棺ҳÇëÇ󣬿ªÊ¼£¬Ò³³õʼ»¯£¬Ò³¼ÓÔØ£¬ÑéÖ¤£¬»Ø·¢Ê¼þ£¬³ÊÏÖ£¬Ð¶ÔØ¡£
ASP.NET Ò³ÔËÐÐʱ£¬´ËÒ³½«¾ÀúÒ»¸öÉúÃüÖÜÆÚ£¬ÔÚÉúÃüÖÜÆÚÖн«Ö´ÐÐһϵÁд¦Àí²½Öè¡£ÕâЩ²½Öè°üÀ¨³õʼ»¯¡¢ÊµÀý»¯¿Ø¼þ¡¢»¹ÔºÍά»¤×´Ì¬¡¢ÔËÐÐʼþ´¦Àí³ÌÐò´úÂëÒÔ¼°½øÐгÊÏÖ¡£Á˽âÒ³µÄÉúÃüÖÜÆÚ·Ç³£ÖØÒª£¬ÕâÑù¾ÍÄÜÔÚºÏÊÊ ......
×î½ü×öµÄϵͳÖÐÀϳöÏÖµÄһЩÎÊÌⲻ̫Ã÷°×£¬ÔÚʹÓà Response.End¡¢Response.Redirect »ò Server.Transfer ʱ³öÏÖ ThreadAbortException £¬±¾À´ÏµÍ³ÊÇûÓÐÎÊÌâµÄ£¬ÔÚ±£´æÊý¾ÝʱҲ¿ÉÒÔÕý³££¬±¾À´Ê¹ÓÃtry-catch Óï¾äÊÇÓÃÀ´²¶»ñÒ»Òì³£Çé¿öµÄ£¬µ«ÏµÍ³Õý³££¬Àϲ¶»ñµ½ÏÂÃæµÄ¶«Î÷
##[²Ù×÷¼Ç¼]£º2010-02-23 9:25:12 Sys ......
ÆäʵÔÚasp.netÖÐÓÃtable±í¸ñ°ó¶¨Êý¾Ý£¬²¢²»ÒªÏñÔÚaspÖÐÄÇôÂé·³£¬ÄÇôÄÑÀí½â£¬Ò²²»ÒªÓÃʲôѻ·Óï¾äÀ´Ò»ÏîÏîµÄ¶ÁÈ¡Êý¾Ý£¬È»ºóÌî³ä±í¸ñ.asp.netÖÐÓÐÒ»¸ö½Ð×öRepeaterµÄ¿Ø¼þ,ÎÒÃÇ¿ÉÒÔÖ±½Ó°Ñ±í¸ñǶÈëµ½Repeater¿Ø¼þÖÐ,È»ºóÉèÖÃRepeate¿Ø¼þµÄDataSourceÊôÐÔ²¢ÈÃÆäDataBind()¾ÍOKÁË......
×öÒ»¸ö²âÊÔ:
ÎÒ´´½¨µÄSQLÊý¾Ý¿âÈçÏÂ:
......