ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS - Web ¿ª·¢ / ASP
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË, ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓà Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý¾Ý¿âÈ¥²éѯ sql="SELECT * from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=c:\test.xls;User ID=Admin;Password=;Extended properties=Excel 5.0') WHERE..." rs.open sql,conn,1,1 ÍøÉÏÒ²ÓкöàʵÀý£¬¶Á±í¸ñºÍ¶ÁÊý¾Ý¿âÆäʵÐÔÖÊÒ»Ñù ÏÖÔÚÓÐÁ½ÖÖÏë·¨ Ò»ÖÖÊǰÑEXCEL±íÖеÄÄÚÈݵ¼ÈëACCESS,È»ºó²éѯACCESS±íÖеÄÄÚÈÝ ÁíÒ»ÖÖÊÇ Ö±½Ó²éѯEXCEL±í ÎҸоõ»¹ÊǵÚÒ»ÖÖºÃЩ,ÒòΪÿ¸öÔ¶¼Óв»Í¬ÄÚÈݵÄEXCEL±íÒªµ¼Èë
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ÎÒÏë´òÓ¡Êý¾Ý¿âÀïÃæ¶ÁÈ¡³öÀ´µÄ¶àÌõÊý¾ÝÄÚÈÝ£¬ÊµÏÖÅúÁ¿´òÓ¡ Ïȵ¼Èëexcel»òÕßword£¬È»ºóÔÚ´òÓ¡ »òÕß¹ºÂòweb´òÓ¡¿Ø¼þ ʹÓÃacitvex´òÓ¡¡£Èç¹û²»ÐèҪѡÔñÊôÐÔ£¬ÉèÖÃÊôÐÔ£¬¾Í²»ÐèÒªÉÌÒµµÄÁË¡£ <style media= ......
protected void btnLogin_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login"); &nb ......
C# code: SqlConnection conn = CsDB.sqlcon(); SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
ÍòÍøµÄ·þÎñÆ÷Ö§³Öα¾²Ì¬µÄ,Ö±½ÓÓÃrewriteÔÚweb.configÎļþд¹æÔò,Ò²²»Óð²×°×é¼þ¾Í¿ÉÒÔʵÏÖα¾²Ì¬,µ«ÊÇÔÚʱ´ú»¥Áª·þÎñÆ÷¾ÍÓò»ÁËÁË,×ÉѯËüµÄ¿Í·þ,Ëû˵ËûÃÇ·þÎñÆ÷(»ù±¾ÐÍC)²»Ö§³Öα¾²Ì¬µÄ.ÇëÎÊһϸ÷λÎÒ¸ÃÓÃʲô·½·¨ ......