asp.net Excelµ¼Èë&µ¼³ö
1¡¢ExcelÊý¾Ýµ¼Èëµ½Êý¾Ý¿âÖУº
//¸Ã·½·¨ÊµÏÖ´ÓExcelÖе¼³öÊý¾Ýµ½DataSetÖУ¬ÆäÖÐfilepathΪExcelÎļþµÄ¾ø¶Ô·¾¶£¬sheetnameΪ±íʾÄǸöExcel±í£»
public DataSet ExcelDataSource( string filepath , string sheetname )
...{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter oada = new OleDbDataAdapter ( "select * from [" + sheetname + "$]", strConn );
DataSet ds = new DataSet ();
oada.Fill ( ds );
return ds ;
}
ÉÏÃæµÄ´úÂëʵÏÖÁ˽«ExcelÖеÄÊý¾Ýд½øDataSetÖУ¬ÊµÏÖÁËÕâÒ»²½ºó£¬Äã¿ÉÒÔ°´ÕÕ×Ô¼ºµÄÐèÒª¶Ô»ñµÃDataSet½øÐд¦Àí£¬ÐèҪעÒâµÄÒ»¸öÎÊÌâÊÇ£¬Äã±ØÐëÒªÖ¸¶¨sheetname£¬¼´ExcelÖеÄÄÄÒ»¸ö¹¤×÷µ¥ÐèÒªµ¼È룬·ñÔò»á³öÏÖ´íÎó¡£
2¡¢ÈçºÎ´ÓExcelÖлñµÃ¹¤×÷µ¥£¨sheetname£©£º
//»ñµÃExcelÖеÄËùÓÐsheetname¡£
public ArrayList ExcelSheetName ( string filepath )
...{
ArrayList al = new ArrayList ();
string strConn;
strConn = "Provider=Microsoft.Jet.
Ïà¹ØÎĵµ£º
<a>±êÇ©
1. <a href=”test.aspx”></a>
2. ÕâÊÇ×î³£¼ûµÄÒ»ÖÖתÏò·½·¨;
HyperLink¿Ø¼þ
1. Asp.net ·þÎñÆ÷¶Ë¿Ø¼þ ÊôÐÔNavigateUrlÖ¸¶ ......
ÏÂÃæ½éÉÜʵÏÖ·½·¨£º
Ò»¡¢ÍÏÀÒ»¸öMenu¿Ø¼þ
Õâ¸ö¿Ø¼þÊǸºÔð¿Ø¼þ¸÷¸öÑ¡ÏµÄ£¬Ò²¾ÍÊÇ×îÖÕ³ÊÏÖÔÚÓû§ÃæÇ°µÄ½çÃæ£¬²¢ÇÒÎÒÃÇÖ¸¶¨Ã¿¸öÑ¡ÏµÄͼƬ¡£
´úÂ룺
<asp:Menu ID="Menu1" runat="server" onmenuitemclick="Menu1_MenuItemClick"
Orientati ......
asp.netʵÏÖÊ¡ÊÐÁª¶¯²¢ÇÒ±£´æ×´Ì¬£¬ÊµÏÖÔÀí£º³õ´ÎʹÓÃC#´«Í³µÄDataBind½øÐÐÊý¾Ý°ó¶¨£¬Ñ¡ÔñÊ¡£¬Êкó½øÐÐajax·½Ê½¼ÓÔØÏ¼¶ÁÐ±í£¬²¢½«Ñ¡¶¨Öµ±£´æµ½HiddenÖУ¬µã»÷Ìá½»ºó¸ù¾ÝHiddenµÄÖµ½øÐÐÊ¡£¬Êа󶨣¬ÔÙ½«HiddenµÄÖµ¸³¸øDropDownListµÄSelectedValue£¬´Ó¶øÊµÏÖ״̬µÄ±£´æ¡£
HTML´úÂë
<asp:HiddenField ID="HiddenField ......
///<summary>
///<author>·ÉÓ¥@ASPCool.com</author>
///<description>±¾ÎÄÓÃasp.netʵÏÖ°Ñ´ËÎÄÍÆ¼ö¸øºÃÓѵŦÄÜ¡£</desciption>
///<copyright>ASP¿á¼¼Êõ×ÊÑ¶Íø(www.ASPCool.com)</copyright>
///</summary ......
¿ª·¢»·¾³:WIN XP VS2005
Êý¾Ý¿â:SQL server 2000
´Ë´¦²»¿¼Âǰ²È«ÎÊÌâ.
¾ßÌåÈçÏÂ:
Ê×ÏȽ¨Á¢Ò»¸öÊý¾Ý¿âºÍÒ»¸ö±í½á¹¹²¢ÔÚ±íÖÐÊäÈëһЩÊý¾ÝÒÔ±ã²âÊÔ:´Ë²½ÂÔ¹ý
´ò¿ªVS2005н¨Ò»¸öÍøÕ¾²¢Ìí¼ÓÒ»¸öHTMLÒ³
ÔÚĬÈϵÄDefault.aspxÖзÅÈëGridview¿Ø¼þÓÃÓÚÏÔʾÊý¾Ý
.cs´úÂë
using System;
using System.Data;
usi ......