Á¬½Ó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
Ïà¹ØÎÊ´ð£º
µÚÒ»´Î½Ó´¥CrystalReport
¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó.
ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл!
¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º
http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË,
ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í,
ÒýÓÃ
Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......