C#ÈçºÎ·ÃÎÊaccessÖеĻõ±Ò×ֶΠ- .NET¼¼Êõ / C#
ÏÂÃæÕâ¶Î´úÂëÊÇÏëʵÏÖ¶ÁÈ¡Êý¾Ý¿â±íÖеĻõ±Ò×Ö¶Îmoney£¬ ²¢½øÐиüУ¬µ«Êǵ÷ÊÔʱ×ÜÔÚ¶ÁÈ¡moneyʱ³ö´í£¨»ÆÉ«´¦£©£¬´ó¼Ò°ïæ¿´¿´£¬Ð»Ð»ÁË~~
db1.oleDbConnection1.Open();
OleDbCommand cmd = new OleDbCommand("select lb.Account,money,LendDate from lb,reader where lb.Account=reader.[account]",db1.oleDbConnection1 );
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
DateTime t_m = dr.GetDateTime(2);
string money_m =dr.GetString (1); string account_m=dr.GetString (0);
DateTime t_now = DateTime.Now;
int days = DateDiff(t_m ,t_now );
if (days > 30)
{
string fee = Convert.ToString((days - 30) * 0.1 + money_m);
OleDbCommand cmd1= new OleDbCommand(string .Format ("update reader set money ='{0}' where [account]='{1}' ",fee,account_m ), db1.oleDbConnection1);
cmd1.ExecuteNonQuery();
}
}
dr.Close();
db1.oleDbConnection1.Close();
»ÆÉ«´¦±¾ÊÇ double money_m =dr.Getdouble (1);Õ³´íÁË¡¡
ʲô´íÎóÌáʾ£¿
Ïà¹ØÎÊ´ð£º
ÇëÎÊVFPÖÐÈçºÎµ÷ÓÃC/C++º¯Êý£¿
ÄãÒªµ÷ÓÃʲô¹¦Äܵĺ¯Êý£¿Òª¿´¿´VFPÖÐÓÐûÓжÔÓ¦µÄº¯Êý£¬Èç¹ûÓоÍÊ¡×ÅÔÙµ÷ÓÃÁË¡£Èç¹ûûÓУ¬¿ÉÒÔ½«C/C++º¯Êýд¸öDLL»òFLL£¬È»ºóÔÚVFPµ÷Óü´¿É¡£
Ê®¶¹Èý ÀÏʦ£¬Ôõô²ÅÄÜÐÞ¸Ä×Ô¼ºµÄ ......
ÓÐÒ»10*10¾ØÕ󣬳ýÈ¥µÚÒ»¸öµã£¨0£¬0£©ºÍ×îºóÒ»µã£¨9£¬9£©£¬»¹Óа˸öµãΪ1£¬ÆäËû¶¼Îª0£¬ÒªÇóÓöþάÊý×é±íʾ¡£°Ë¸öµãÊÇËæ»úÉú³ÉµÄ£¬±àдÏà¹Ø³ÌÐò±íʾ¾ØÕóËùÓпÉÄÜÇé¿ö¡£
ÕæÐÄÇó½Ì¸÷λ¸ßÊÖ£¬°¥£¡±¾ÈËÌ«²ËÁË£¡ºÇºÇ£¡
......
ΪʲôÎҵijÌÐòµ÷ÓÃXMLÅäÖÃÎļþÖеİ¢À²®ÎÄÏÔʾ²»³öÀ´£¿ÆäËûµÄÓïÖÖ¶¼¿ÉÒÔ£¬ÈçÖÐÎÄ£¬Ó¢ÎÄ£¬µÂÎĶ¼¿É¡£
ÎÒ½«XMLµÄ±àÂë¸ÄΪutf-8ºÍunicodeµÄµ½µÃ½á¹û¶¼Ò»Ñù.
°¢À²®ÎĵÄ×Ö¿âÄãÓÐô£¿
ÓÐ,ÎÒµÄEXEÊÇ·ÅÔÚpc»úÉÏÖ´Ðе ......
ÎÒÁ¬½ÓaccessÊý¾Ý¿â£¬ÒÔÇ°Ò»Ö±ºÜºÃ£¬×î½üÈ´×ÜÊdzö´í£¨Êý¾Ý¿âÁ¬½Ó³ö´í!£¡£©£¬´úÂëÈçÏ£º
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&" ......
¹«Ë¾¿ª·¢Ò»¸ö´¥ÃþÆÁ³ÌÐò£¬ÎÒ¸ºÔðµÄÒ»¿é£¬ÊµÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬µ±Êó±êµã»÷´°¿ÚÖÐͼƬ£¨Ò»ÕÅͼ·Ö³É¼¸²¿·Ö£©µÄÆäÖÐÒ»²¿·Öʱ£¬½«Õⲿ·ÖͼƬ½ØÈ¡³öÀ´£¬µ¯³öеĴ°¿Ú£¬½«½ØÈ¡³öµÄͼƬÏÔʾ³öÀ´¡£ÎÒʹÓÃRectangeÀà¿ØÖÆÁË·µ»Ø£¬ ......