Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

Vb.net Access CrystalReport - .NET¼¼Êõ / VB.NET

µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......

ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS - Web ¿ª·¢ / ASP

ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,

ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......

ÈçºÎÔÚVB.NET´´½¨accessÊý¾Ý¿â£¿

¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......

ACCESSÈ¥³ýÖØ¸´Öµ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ