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

C#ÖÐÁ¬½Ó¼°²éѯAccess³öÏÖµÄÎÊÌâ

´óÏÀÃÇ£º
    ÕâÊÇÎÒÁ¬½ÓÊý¾Ý¿âµÄ´úÂë
            string strPath = Application.StartupPath + "\\Database.accdb";
            string ConStr = "provider=Microsoft.jet.oledb.4.0;Data source=" + strPath;
            OleDbConnection Olecon = new OleDbConnection(ConStr);
            Olecon.Open();
            string sql = "Select * from ѧÉúÐÅÏ¢ where ѧºÅ= '" + textBox1.Text.Trim() + "' ";
            OleDbDataAdapter da = new OleDbDataAdapter(sql, Olecon);
            DataSet ds = new DataSet();
            da.Fill(ds, "ѧÉúÐÅÏ¢");
            this.dataGridView1.DataSource = ds.Tables[0];
    ±¨´í£º
    {"ÕÒ²»µ½Îļþ 'E:\\Êý¾Ý¿â»ù±¾²Ù×÷\\Êý¾Ý¿â»ù±¾²Ù×÷\\bin\\Debug\\Database.accdb'¡£"}
    ʲôԭÒòÄØ¡­¡­
C# code:
@'E:\Êý¾Ý¿â»ù±¾²Ù×÷\Êý¾Ý¿â»ù±¾²Ù×÷\bin\Debug\Database.accdb'
??

ÄDz»ÊÇ˵ÁËÂð ÕÒ²»µ½Îļþ ÄãÄǸö·¾¶ÏÂÓÐÕâ¸öÎļþÂð£¿

C# code



Code highlighting produced by


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......

c# Óëjava

ÎÒÃ÷ÄêÁ˾ÍÒª±ÏÒµÁË ¿´µ½ÕÐÆ¸ÍøÉ϶àÊý¶¼ÊÇÕÐjavaµÄ      ÊDz»ÊÇѧjava±Èc#ºÃÕÒ¹¤×÷ÄØ£¿
ÃÔã°¡
²»ÊÇÕâÑù °¡
ÒªÊÇÄãµÄc#ѧϰµÄºÃµÄ»°
Ò²¿ÉÒԵõ½ºÃµÄ¹¤×÷°¡
²»ÊÇÂð?
Õâ¸öÎÊÌâ¹Ø¼üÔÚÓÚ ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......

c# µ¼³ö´¿Õæip¿âµ½sqlserver

ÎÒÏë°Ñ´¿Õæip¿âµ¼³öµ½sqlserver£¬ÎÒÓÃϱߵĽéÉÜ·½·¨£¬£¨ËüÖ÷ÒªÊǵ¥¸öIP²éѯµÄ£©
http://www.cnblogs.com/njnudt/archive/2007/04/08/704524.html
¸ÄÁËÒ»ÏÂÄܹ»µÃµ½ËùÓеĹú¼ÒºÍµØÇøÐÅÏ¢£¬µ«ÊDz»Äܵõ½ipµØÖ·µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ