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

ASP.NETÖÐÊý¾Ý¿âÊý¾Ýµ¼ÈëExcel²¢´òÓ¡

ÖÚËùÖÜÖª£¬WEBÉϵĴòÓ¡ÊDZȽÏÀ§Äѵ쬳£¼ûµÄWEBÉÏ´òÓ¡µÄ·½·¨´ó¸ÅÓÐÈýÖÖ£º
¡¡¡¡1¡¢Ö±½ÓÀûÓÃIEµÄ´òÓ¡¹¦ÄÜ¡£Ò»°ãÀ´Ëµ£¬ÕâÖÖ·½·¨¿ÉÒÔ×öЩÀ©Õ¹£¬¶ø²»Êǵ¥µ¥µÄµ÷ÓÃjavascript:print()ÕâÑù¼òµ¥£¬±ÈÈ磬¿ÉÒÔʹÓÃÈçÏ´úÂ룺
£¼OBJECT
id=WebBrowser classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 width=0£¾
£¼/OBJECT£¾
£¼input
type=button value=´òÓ¡ onclick=document.all.WebBrowser.ExecWB(6,1)£¾
£¼input
type=button value=Ö±½Ó´òÓ¡ onclick=document.all.WebBrowser.ExecWB(6,6)£¾
£¼input
type=button value=Ò³ÃæÉèÖà onclick=document.all.WebBrowser.ExecWB(8,1)£¾
£¼input
type=button value=´òÓ¡Ô¤ÀÀ onclick=document.all.WebBrowser.ExecWB(7,1)£¾
¡¡¡¡ÕâÖÖ·½·¨¿ÉÒÔÊÊÓÃÓÚ¼òµ¥µÄÊý¾Ý´òÓ¡£¬¶ÔϵͳҪÇ󲻸ߣ¬µ«²»×ãÖ®´¦ÔÚÓÚ¿ÉÒÔ¿ØÖƵÄÄÜÁ¦±È½Ï²î£¬±ÈÈç´¦Àí·ÖÒ³µÈÎÊÌâ¡£
¡¡¡¡2¡¢ÀûÓÃË®¾§±¨±í»òÆäËûµÚÈý·½¹¤¾ß£¬Èç΢ÈíµÄReporting service¡£Ë®¾§±¨±í»òÆäËûµÚÈý·½¿Ø¼þµÄ´òÓ¡£¬Ò»°ãÊǵ¼³öµ½Excel£¬WORD£¬PDFµÈÔÙ½øÐдòÓ¡µÄ£¬Ð§¹û±È½ÏºÃ£¬µ«±à³Ì±È½Ï¸´ÔÓ£¬¿ØÖÆÆðÀ´Ò²²»´ó·½±ã£¬¶øÇÒÕâЩ¹¤¾ß¶¼ÊÇÒªÊշѵġ£
¡¡¡¡3¡¢½«Êý¾Ý¿âµÄÊý¾Ý»òÒª´òÓ¡µÄÄÚÈݵ¼³öµ½Excel£¬WordÖÐÈ¥´òÓ¡¡£Ê¹ÓÃÕâÖÖ·½·¨£¬¿ÉÒÔÔÚ·þÎñ¶Ë»òÕ߿ͻ§¶Ë½øÐС£ÔÚ·þÎñ¶ËʹÓõϰ£¬ÒªÇó·þÎñ¶ËÒª°²×°Word£¬Excel£¬ÔÚ¿Í»§¶ËʹÓõϰ£¬ÒªÇó¿Í»§¶ËÔÚIEµÄ°²È«ÉèÖÃÉÏÓÐÒ»¶¨ÒªÇó¡£Ê¹ÓÃÕâÖÖ·½·¨£¬¿ÉÊÊÓ¦ÐԱȽÏÇ¿£¬¿ØÖƽϺᣱ¾ÎĽ«ÒÔÔÚASP.NETÖÐʹÓÃExcelΪÀý×Ó£¬½éÉÜÈçºÎ½«Êý¾Ýµ¼³öµ½ExcelµÄ¼¸ÖÖ·½·¨¡£
¡¡¡¡Ê×ÏÈ£¬ÏȽéÉÜÔÚ·þÎñ¶ËʹÓÃExcelµÄ·½·¨¡£ÒªÔÚ·þÎñÆ÷¶ËʹÓÃExcel£¬±ØÐëÒªÇó·þÎñÆ÷¶Ë°²×°Excel,²¢ÇÒÒªÇóÒ»¶¨µÄ·ÃÎÊȨÏÞ¡£±ÈÈ磬ÐèÒªÌí¼Ó£¼identity impersonate="true"/£¾µ½web.configÖС£ÔÚ±¾ÎÄÖУ¬Òª¸øÓèWEBĿ¼¿ÉдµÄȨÏÞ¡£
¡¡¡¡½ÓÏÂÀ´£¬Ê¹ÓÃVS.NET 2003н¨Ò»¸öVB.NETµÄ¹¤³Ì£¬²¢Ìí¼ÓÒýÓá£ÓÉÓÚÎÒÃÇҪʹÓõÄÊÇExcel£¬ËùÒÔÌí¼ÓÒ»¸ö¹ØÓÚCOMµÄÓ¦Óã¬ÕâÀïÌí¼ÓµÄÊÇMicrosoft Excel Object Library£¬Ö®ºó£¬Ìí¼ÓµÄ´úÂëÈçÏ£º
Imports System.Runtime.InteropServices.Marshal
Imports Office
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
¡¡'ÒÔCOM·½Ê½´¦ÀíExcel
¡¡Dim oExcel As New Excel.Application
¡¡Dim oBooks As Excel.Workbooks, oBook As Excel.Workbook
¡¡Dim oSheets As Excel.Sheet


Ïà¹ØÎĵµ£º

ASP.NET MVC£ºÈçºÎʵÏÖÒ»¸ö×Ô¼ºµÄModelBinder£¿

»·¾³£º
Windows 2008, VS 2008 SP1, Asp.Net Mvc RC1
------------------------------------------------------------------------------
ÉÏÎÄ£ºAsp.Net Mvc: Model Binding »úÖÆ·ÖÎö  ÖУ¬ÎÒÃǼòµ¥·ÖÎöÁËAsp.Net MvcÖÐModel BindingµÄ¹ý³Ì£¬·Ç³£´Ö²Ú£¬±¾ÎĽ«Ì½Ë÷ÈçºÎʵÏÖÒ»¸ö×Ô¼ºµÄModelBinder£¬²¢½øÒ»²½Õ¹Ê¾Ç°Îĺ ......

asp.net(c#)»º´æCache¶ÔÏó£¨Ñ§Ï°ÈÕ¼ÇÒ»£©


ʲôÊÇCache¶ÔÏó?
ÄãÔÚÉú³É¸ßÐÔÄÜÍøÂçÓ¦ÓóÌÐòʱËùÓöµ½µÄÒ»¸öÎÊÌâ¾ÍÊÇÐèÒª±ÜÃâÖØ¸´¡£Ò»¸öCache¶ÔÏóÔÊÐíÔÚËüÃǵÚÒ»´Î±»ÇëÇóʱÔÚÄÚ´æÖлº´æÏȻºó½«±»»º´æµÄ¸±±¾ÓÃÓÚÒÔºóµÄÇëÇó¡£Ê¹Óñ»»º´æµÄ¸±±¾ÔÊÐíÄã±ÜÃâÖØ½¨Âú×ãÒÔǰÇëÇóµÄÐÅÏ¢£¬ÌرðÊÇÄÇЩÿ´Î´´½¨Ê±¶¼ÐèÕ¼ÓÐÃ÷ʾµÄ·þÎñÆ÷ÉϵĴ¦ÀíÆ÷ʱ¼äµÄÃüÁî¡£
³ý»º´æ¸ö±ðÏÈç» ......

asp.net ö¾Ù string×Ö·û´® תΪºº×Ö

   public static string TheColor(string color,string enumName)
        {
            return string.Format("<span style=\"color={0}\">{1}</span>",color,enumName);
     ......

dzµ­asp.netÖÐGridView+CheckBoxʵÏÖȫѡ/·´Ñ¡/ɾ³ý

½ñÌìÔÚʵÏÖÈçÌâÄÚÈÝʱ£¬Ê¼ÖÕ³öÏÖÁËһЩÎÊÌ⣬ÔÚÂÛ̳ÁôÑÔ£¬»Ø¸´ÕßÉõ¶à£¬µ«Ò²Á¼Ý¬²»Æë£¬ËìÔÚÍ´¿à¼å°¾µÄÕûÀíºó£¬Éú³ö´ËÎÄ
±¾ÎĽöΪһÖÖGridView+CheckBoxʵÏÖȫѡ/·´Ñ¡/ɾ³ýµÄ·½·¨£¬½ö¹©´ó¼Ò²Î¿¼£¬»¶Ó­´ó¼ÒÌá³ö×Ô¼º±¦¹óÒâ¼û
demo.aspxÒ³Ãæ
<!-- ÂÔ-->
<asp:GridView id="GvContent"  runat="server" &g ......

asp.net ÎÄÕÂÄÚÈÝ·ÖÒ³ÏÔʾµÄ´úÂë

aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ArticlePage.aspx.cs" Inherits="ArticlePage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" > ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ