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

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Ö®·Ö²¼Ê½ÊÂÎñ

SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
 ÊÕ²Ø
--> Title  : SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
--> Author : wufeng4552
 
--> Date   : 2009-11-11
 
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
 
(Ò»)¸ÅÄî:
 
·Ö²¼Ê½ÊÂÎñÊÇÉæ¼°À´×ÔÁ½¸ö»ò¶à¸öÔ´µÄ×ÊÔ´µÄÊÂÎñ¡£Microsoft® SQL Serv ......

Sql Server 2008 Reporting ServicesϵÁУ¨Ò»£©

Ò»¡¢Á˽âReporting Services
     Sqlserver Reporting ServicesÊÇ΢ÈíµÄÊý¾Ý¿â±¨±íÉè¼Æ¹¤¾ß£¬Ëü¼¯³ÉÔÚ΢ÈíµÄÉÌÒµÖÇÄÜ¿ª·¢¹¤¾ß£ºSQL Server Business Intelligence Development StudioÖ®ÖУ¬Õâ¸ö¹¤¾ßÆäʵ¾ÍÊÇ´ó¼ÒÊìϤµÄVisual Studio£¬ÀûÓÃReporting ServicesÎÒôÄܹ»¸ßЧµÄ¿ª·¢Êý¾Ý±¨±í£¬Reporting S ......

ASP.NET¿ªÔ´CMS

1. DotNetNuke(ASP.NET 2.0) ¸öÈËÍÆ¼öÉîÈëÑо¿
DotNetNukeÊÇÒ»¸öWebÓ¦Óÿò¼ÜµÄÀíÏë,Ϊ´´½¨ºÍ²¿ÊðµÄÏîÄ¿,ÈçÉÌÒµÍøÕ¾,ÆóÒµÄÚÁªÍøºÍÍâÁªÍø,ÔÚÍøÉϳö°æÃÅ»§,²¢¶¨ÖÆ´¹Ö±Ó¦ÓÃÈí¼þ¡£ ·½±ãÓû§-DotNetNukeÖ¼ÔÚʹÓû§¿ÉÒÔ¸üÇáËɵعÜÀíËùÓз½ÃæµÄÏîÄ¿¡£
ÏÂÔØÍøÖ·:http://www.dotnetnuke.com/
2¡¢Ludico
LudicoÊÇC#±àдµÄ¾ÓÓÚASP ......

д¸øÄÇЩASP.NET³ÌÐòÔ±£ºÍøÕ¾ÖеݲȫÎÊÌâ

ÔÚÍøÂç¾­³£¿´µ½ÍøÕ¾±»¹ÒÂí¡¢Ö÷Ò³±»Ð޸ĵÄÐÂÎÅ£¬ÆäʵÕâЩÎÊÌâ¿ÉÄÜÊÇ¶à·½ÃæµÄ£¬·þÎñÆ÷£¬ÍøÕ¾³ÌÐòµÈµÈ¡£¡£¡£µ«ÊÇÏÖÔÚÒç³öÒѾ­±»ÈËÃÇÖØÊӺͷþÎñÆ÷µÄ²»¶ÏÍêÉÆ£¬·þÎñÆ÷ϵͳ©¶´Ò²²»ÊÇÄÇôÈÝÒ×·¢¾ò£¬µ±È»Ò²Òª±£Ö¤µÚÈý·½µÄÈí¼þ°²È«¡£
×öÏîĿҲÓÐÒ»¶Îʱ¼äÁË¡£ÔÚ³ÌÐòÖÐÒ²Óöµ½ºÜ¶à°²È«·½ÃæµÄÎÊÌâ¡£Ò²¸Ã×ܽáÒ»ÏÂÁË¡£Õâ¸öÏîÄ¿ÊÇÒ»¸öCMSÏ ......

Asp.net treeviewʵÏÖÎÞÏÞ¼¶Ê÷ʵÏÖ´úÂë

×î½üÑо¿ÁËÒ»ÏÂtreeview£¬·¢ÏÖÓÐÁ½ÖÖʵÏÖÎÞÏÞ¼¶Ê÷µÄ·½·¨£¬ÎÄ×Ö²»Ïë¶àд£¬Ö±ÈëÖ÷Ìâ¡£
ÏÈ¿´¿´Ð§¹ûͼ£º
ÏÈ¿´¿´Êý¾Ý¿â±íµÄÉè¼Æ£¬Êý¾Ý±íÖ÷Òª°üÀ¨ID£¬Name£¬ParentIDÕâÈýÏÆäÖÐIDÊÇÖ÷¼ü£¬ParentID¶ÔÓ¦½ÚµãµÄ¸¸½Úµã£º
·½·¨Ò»£ºÓõݹé±éÀúÊý¾Ý£¬²¢½«½ÚµãÖð¸öÌí¼Óµ½treeviewÖÐÈ¥¡£
1.ÏȽøÐÐÊý¾Ý¿âÁ¬½ÓºÍÊý¾ÝµÄ¶ÁÈ¡£¬²¢½«¸ù½Ú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ