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

Á¬½ÓACCESSÊý¾Ý¿â·¢Éú´íÎó

private void but_login_Click(object sender, EventArgs e)
  {
  string constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\³ÌÐòÁ·Ï°\\database\\data.accdb;Persist Security Info=False ";
  OdbcCommand comm = new OdbcCommand();
  OdbcConnection conn = new OdbcConnection();
  conn.ConnectionString = constring;
  comm.Connection = conn;
  conn.Open();
  comm.CommandText = "select * from user where user_name="+teb_username.Text +"and user_password="+teb_password.Text;
  OdbcDataReader reader = new OdbcDataReader();
  reader = comm.ExecuteReader();
  if (reader.HasRows)
.........
ÔÚconn.open();ÖгöÏÖ´íÎó£¬ÌáʾERROR [IM002] [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\½Ìѧ\HandsOn\DesignPattern\SimpleFactory\SF.mdb;User Id=admin;Password=;

ÕâÊÇÎÒÔÚÅäÖÃÎļþдµÄ×Ö·û´®£¬Äã±È½Ïһϰ¡

\\data.accdb

accessÓ¦¸ÃÊÇmdb½áβ°É£¿

Ó¦¸ÃÊÇÄãµÄÁ¬½Ó×Ö·û´®ÓÐÎÊÌâ accessÊý¾Ý¿âµÄºó׺ÃûÊÇmdb°É »¹ÓоÍÊǰÑpersist security InfoÉèÖÃΪTrueÊÔÒ»ÊÔ

ûÁ¬ÉϿ⣬¼ì²éÁ¬½Ó´®Óï¾ä´íÎó¡£

½¨Ò飺
ÔÚweb.config/app.configÖж¨Òå
<add key="DatabaseType" value="Oledb"/>
<add key="ConnectionString" value="provider=microsoft.jet.oledb.4.0;Data Source="/>


Ïà¹ØÎÊ´ð£º

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

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

dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌâ

ÈçÌâ dOOdads Á¬½Ó ACCESS µÄÊý¾Ý·ÖÒ³ÎÊÌ⣡
ʹÓà dOOdads Á¬½Ó ACCESSÊý¾ÝµÄʱºò Êý¾Ý·ÖÒ³µÄÎÊÌ⣡
¸ù¾ÝÕâ¸ö¸Ä°É
C# code:

public static Product[] SearchProducts(string keyword, int categoryID, int pa ......

ACCESSÖ§³ÖÁ¬½Ó³ØÂð - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿

×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿

Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx

×î¶àÖ§³Ö¶àÉÙ²¢· ......

ÓÃDTSµ¼³öΪaccessÎļþ³ö´í - MS-SQL Server / »ù´¡Àà

±í½á¹¹ÊÇÕâÑùµÄ£º
µ«ÎÒÓÃDTSµ¼³öµÄʱºò³ö´íÁË£º
²Ù×÷ÒÑÍ£Ö¹...
- ÕýÔÚ³õʼ»¯Êý¾ÝÁ÷ÈÎÎñ (³É¹¦)
- ÕýÔÚ³õʼ»¯Á¬½Ó (³É¹¦)
- ÕýÔÚÉèÖà SQL ÃüÁî (³É¹¦)
- ÕýÔÚÉèÖÃÔ´Á¬½Ó (³É¹¦)
- ÕýÔÚÉèÖÃÄ¿±êÁ¬½Ó (³É¹¦)
- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ