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

Á¬½ÓACCESSÊý¾Ý¿âÊÇ·¢Éú´íÎó£¬ÇëÖ¸½Ì¡£

private void but_login_Click(object sender, EventArgs e)
  {
  string constring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\Administrator\\×ÀÃæ\\xx.mdb;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)
  {
  label1.Text = "yes";
  }
  else
  label1.Text = "no";
   
  }

´úÂëÈçÉÏ£¬µ«ÊÇÔÚOdbcDataReader reader = new OdbcDataReader();Éϳö´í£¬ÌáʾÐÅÏ¢ÊÇ£º
system.data.odbc.odbcdatareader 䶨Òå¹¹Ô캯Êý¡£

ллָ½Ì
OdbcDataReader reader = new OdbcDataReader();
  reader = comm.ExecuteReader();

ÕâÁ½¾ä»°£¬¸Ä³É:

OdbcDataReader reader = comm.ExecuteReader();

comm.ExecuteReader()µÄ·µ»Ø¾ÍÊÇÒ»¸örea


Ïà¹ØÎÊ´ð£º

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

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

VCÖÐ odbc·ÃÎÊaccessÄÚ´æÔö³¤

vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......

²éѯACCESSÖзûºÏÌõ¼þ¼Ç¼µÄÓï·¨¸ñʽ

ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......

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

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

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

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

×î¶àÖ§³Ö¶àÉÙ²¢· ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ