Á¬½Ó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
Ïà¹ØÎÊ´ð£º
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ÎÒÔÚVC++ÀﶨÒåÁ˼¸¸öÈ«¾Ö±äÁ¿£¬¾¹ýһϵÁеļÆËãÖ®ºó£¬½«ÕâЩȫ¾Ö±äÁ¿µÄÖµ´æµ½ACCESS¶ÔÓ¦µÄ×Ö¶ÎÏÂÃæ¡£²»Öª¸ÃÈçºÎʵÏÖ¡£Õ⼸¸ö±äÁ¿ÓÐSTRING£¬Ò²ÓÐDOUBLEÀàÐ͵ġ£¸ÃACCESS²»ÓëÈκζԻ°¿òÓбäÁ¿Êý¾Ý´«µÝµÄÁªÏµ£¬½ö ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......