asp.net ½«Excelµ¼Èëµ½Sql2005»ò2000
asp.net ½«Excelµ¼Èëµ½Sql2005»ò2000µÄ˼·ºÍ²½Ö裺
1¡¢½«ExcelÎļþÉÏ´«µ½·þÎñÆ÷¶Ë
Õâ¸öÎÒ²»ÏëÏêϸ½²ÁË,ÍøÉÏÒ»ËÑÒ»´ó°ÑµÄ.
×¢Ò⣺£¨1ÔÚÈ¡·þÎñÆ÷·¾¶Ê±Ò»¶¨ÒªÓÃthis.Page.MapPath(".")¶ø²»ÒªÓà this.Page.Request.ApplicationPath »òthis.Page.Request.Path;ÒòΪºóÁ½¸öÔÚµ÷ÊÔµÄʱºò¿ÉÄܲ»±¨´í,µ«ÔÚ·¢²¼Ê±»á±¨´í¡£
£¨2 Õ¾µã¸ùĿ¼Ҫ¸øAsp.netÓû§Ð´µÄȨÏÞ¡£·ñÔòÎļþÉÏ´«²»ÉÏÈ¥µÄ£¬±¨¾Ü¾ø·ÃÎÊ.
2¡¢½«·þÎñÆ÷¶ËµÄEXcelÊý¾Ý¶ÁÈëÄÚ´æ
private static DataTable getXslTable(string XlsFileName)//´ÓexcelÖжÁÈ¡Êý¾Ý,²¢·Åµ½DataTableÖÐ
{
DataSet ZDDataSet = new DataSet();
System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection("Provider=Microsoft.jet.OLEDB.4.0;Data Source=" + XlsFileName + ";Extended Properties=Excel 8.0");//Õâ¸ö¸ü¾Ý²»Í¬µÄExcel°æ±¾²»Ò»Ñù
//XlsFileName ΪExcelµÄ·¾¶
objConn.Open();
//DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
// String tableName = schemaTable.Rows[0][2].ToString().Trim();
string SqlStr = "Select * from [CPCMLFXB$]";//CPCMLFXBÊÇÒª¶ÁµÄSheetµÄÃû×Ö
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(SqlStr, objConn);
System.Data.OleDb.OleDbDataAdapter DAP = new System.Data.OleDb.OleDbDataAdapter(command);
DAP.Fill(ZDDataSet, "CPCMLFXB");
objConn.C
Ïà¹ØÎĵµ£º
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
ÊÕ²Ø
--> Title : SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
--> Author : wufeng4552
--> Date : 2009-11-11
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
(Ò»)¸ÅÄî:
·Ö²¼Ê½ÊÂÎñÊÇÉæ¼°À´×ÔÁ½¸ö»ò¶à¸öÔ´µÄ×ÊÔ´µÄÊÂÎñ¡£Microsoft® SQL Serv ......
Ò»¡¢Á˽âReporting Services
Sqlserver Reporting ServicesÊÇ΢ÈíµÄÊý¾Ý¿â±¨±íÉè¼Æ¹¤¾ß£¬Ëü¼¯³ÉÔÚ΢ÈíµÄÉÌÒµÖÇÄÜ¿ª·¢¹¤¾ß£ºSQL Server Business Intelligence Development StudioÖ®ÖУ¬Õâ¸ö¹¤¾ßÆäʵ¾ÍÊÇ´ó¼ÒÊìϤµÄVisual Studio£¬ÀûÓÃReporting ServicesÎÒôÄܹ»¸ßЧµÄ¿ª·¢Êý¾Ý±¨±í£¬Reporting S ......
1. DotNetNuke(ASP.NET 2.0) ¸öÈËÍÆ¼öÉîÈëÑо¿
DotNetNukeÊÇÒ»¸öWebÓ¦Óÿò¼ÜµÄÀíÏë,Ϊ´´½¨ºÍ²¿ÊðµÄÏîÄ¿,ÈçÉÌÒµÍøÕ¾,ÆóÒµÄÚÁªÍøºÍÍâÁªÍø,ÔÚÍøÉϳö°æÃÅ»§,²¢¶¨ÖÆ´¹Ö±Ó¦ÓÃÈí¼þ¡£ ·½±ãÓû§-DotNetNukeÖ¼ÔÚʹÓû§¿ÉÒÔ¸üÇáËɵعÜÀíËùÓз½ÃæµÄÏîÄ¿¡£
ÏÂÔØÍøÖ·:http://www.dotnetnuke.com/
2¡¢Ludico
LudicoÊÇC#±àдµÄ¾ÓÓÚASP ......
ÔÚÍøÂç¾³£¿´µ½ÍøÕ¾±»¹ÒÂí¡¢Ö÷Ò³±»Ð޸ĵÄÐÂÎÅ£¬ÆäʵÕâЩÎÊÌâ¿ÉÄÜÊÇ¶à·½ÃæµÄ£¬·þÎñÆ÷£¬ÍøÕ¾³ÌÐòµÈµÈ¡£¡£¡£µ«ÊÇÏÖÔÚÒç³öÒѾ±»ÈËÃÇÖØÊӺͷþÎñÆ÷µÄ²»¶ÏÍêÉÆ£¬·þÎñÆ÷ϵͳ©¶´Ò²²»ÊÇÄÇôÈÝÒ×·¢¾ò£¬µ±È»Ò²Òª±£Ö¤µÚÈý·½µÄÈí¼þ°²È«¡£
×öÏîĿҲÓÐÒ»¶Îʱ¼äÁË¡£ÔÚ³ÌÐòÖÐÒ²Óöµ½ºÜ¶à°²È«·½ÃæµÄÎÊÌâ¡£Ò²¸Ã×ܽáÒ»ÏÂÁË¡£Õâ¸öÏîÄ¿ÊÇÒ»¸öCMSÏ ......
×î½üÑо¿ÁËÒ»ÏÂtreeview£¬·¢ÏÖÓÐÁ½ÖÖʵÏÖÎÞÏÞ¼¶Ê÷µÄ·½·¨£¬ÎÄ×Ö²»Ïë¶àд£¬Ö±ÈëÖ÷Ìâ¡£
ÏÈ¿´¿´Ð§¹ûͼ£º
ÏÈ¿´¿´Êý¾Ý¿â±íµÄÉè¼Æ£¬Êý¾Ý±íÖ÷Òª°üÀ¨ID£¬Name£¬ParentIDÕâÈýÏÆäÖÐIDÊÇÖ÷¼ü£¬ParentID¶ÔÓ¦½ÚµãµÄ¸¸½Úµã£º
·½·¨Ò»£ºÓõݹé±éÀúÊý¾Ý£¬²¢½«½ÚµãÖð¸öÌí¼Óµ½treeviewÖÐÈ¥¡£
1.ÏȽøÐÐÊý¾Ý¿âÁ¬½ÓºÍÊý¾ÝµÄ¶ÁÈ¡£¬²¢½«¸ù½Ú ......