ÈçÌ⣬excel±íÖÐÓÐ×Ö¶Î ¡°¿ÆÄ¿¡±£¬ÆäֵΪ1»ò2£¬£¨×¢£º´Ëexcel±íÒ²ÊÇ´ÓÆäËûÊý¾Ý¿âÖе¼³öÀ´µÄ£¬¹À¼ÆÔÀ´µÄÖµÓ¦¸ÃÊÇ1±íʾÊýѧ£¬2±íʾӢÓµ«²»ÖªºÎ¹Ê£¬µ¼³öÀ´µÄÖµ¾ÍֻʣÏÂÊý×Ö£©
ÑÔ¹éÕý´«£¬ÏÖ½«¿ÆÄ¿µ¼Èëaccess£¬Ôõô²ÅÄÜÈÃÆä»Ö¸´ÔÖµ£¿¼´£ºÏÔʾ1µÄµØ·½£¬Ö»ÏÔʾÊýѧ£»
ÏÔʾ2µØ·½Ö»ÏÔʾӢÓ
ÓÐûÓмòµ¥µÄ·½· ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´Å¥Ê±£©¡£
ÎÒµÄÓï¾äÈçÏ£º
string txt2 ="selcet * from Student where SutdentName='"+textBox ......
rt
µ÷ÓÃ Worksheet.PrintOut ·½·¨
µÄǰÌáÊDz»ÊÇ£¬ÔËÐгÌÐòµÄϵͳ»·¾³
Àï±ØÐë°²×°ÓÐexcel£¿
Êǵ쬱ØÐë°²×°EXCEL¡£·ñÔòÄã¾ÍÐèÒª×Ô¼ºÀ´ÓóÌÐò´¦ÀíXLSÎļþµÄ¸ñʽ£¬Õâ¸ö¾ÍÐèÒª»¨ºÜ´óµÄ¾«Á¦ÁË¡£
Dim excel As Object
Dim workbook As Object
Dim worksheet As ......
ÎÒÔÚVS2008ÖеķþÎñÆ÷×ÊÔ´¹ÜÀíÆ÷ÖÐÌí¼ÓÒ»¸öAccessÊý¾Ý¿âÎļþµÄÁ¬½Ó
ÔÚ"Ìí¼ÓÁ¬½Ó"´°¿ÚÖ¸¶¨ÍêÊý¾Ý¿âÎļþºó,µã²âÊÔÁ¬½Ó»òÈ·¶¨,¾Íµ¯³ö"δָ¶¨µÄ´íÎó",
(ÒªÇóÓÃAccessÊý¾Ý¿â,±¾È˶ԴËÊý¾Ý¿â²»Ì«ÊìϤ,ÒÔǰÊÇÓÃsqlserverµÄ)
ÉÏÍø²é½â¾ö·½·¨,δ¹û....
ÓÚÊǵ½ÕâÀïÀ´Çë½ÌÏÂ,(²»ÖªµÀÓÐûÓз¢´í°æ¿é),Ï ......
¸÷λ´óϺ£º
ÈçºÎÓÃ.net×öÒ»¸öСÈí¼þ£¬½«accessÖÐÊý¾Ý´«µ½oracleÊý¾Ý¿âÖÐ,¸ÃСÈí¼þ½«»á·ÅÔÚÎÒÒѾ×öºÃµÄÈí¼þÄÚ¡£
Çë´ó¼Ò°ïæÀ²£¡£¡£¡
Õâ¸öÈí¼þ²»Ð¡...
1.½¨Á¢Á½¸öÊý¾Ý¿âÁ¬½Ó£¬A¶ÁAccess,BдOrical;
2.ÓÃÓ¦ÓóÌÐòÊÂÎñ¿ØÖÆÁ½¸ö¶Áдͬʱ³É¹¦»òÕßʧ°Ü¡£
ÒýÓÃ
Õâ¸öÈí¼þ²»Ð¡...
Õâ¸öÈí¼þº ......
ÎÒ»áʹÓÃsql server2005
µ«ÊÇÎÒ²»»áʹÓÃaccess...
VB.NET code:
Imports Microsoft.VisualBasic
Imports System.Data.SqlClient
Public Class cls_conn
Dim conn As New SqlConnection
Sub New()
conn.ConnectionString = "data source=.\sqlexpress;initial catalog=fif;int ......