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

accessÊý¾Ý¿â×óÍâÁ¬½Ó²éѯÎÊÌâ

string sql =" select vm.[units],sum(ts.[Dealmoney]),sum(vm.[onbaoxiao]),sum(vm.[nianbaoxiao]) from VehicMessage vm LEFT JOIN TecSystem ts on vm.card=ts.card group by vm.[card],vm.[units]";

  OleDbCommand com = new OleDbCommand(sql);
OleDbDataReader reader = com.ExecuteReader();-------±¨´í£¬{"ÖÁÉÙÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ¡£"}

»¹Çë¸ßÊÖ°ï°ï棿ллÁË
СµÜ¸ÕÀ´»¹Ã»»ý·Ö£¬»¹Íû¼ûÁÂ~~~~
console.writeline (sql)

Ìù³ö½á¹û£¬È»ºó°ÑÕâ¸öSQLÓï¾äÖ±½Óµ½ACCESSÖеIJéѯÖÐÊÔһϡ£Ëü»á¸æËßÄãʲô¶«Î÷²»¶ÔµÄ¡£

¹À¼ÆÄãд´íÁË×Ö¶ÎÃû¡£

×Ö¶ÎûÓÐд´í£¬ÎÒÖ´Ðе¥±í²éѯµÄʱºòûÎÊÌ⣬һÓõ½Á¬½Ó²éѯ¾Í±¨´íÁË~~£¿

Êý¾Ý¿âÀïµÄÓÐÒ»ÁÐֵΪnull £¬»áÓ°ÏìÂð?

ÒýÓÃ×Ö¶ÎûÓÐд´í£¬ÎÒÖ´Ðе¥±í²éѯµÄʱºòûÎÊÌ⣬һÓõ½Á¬½Ó²éѯ¾Í±¨´íÁË~~£¿


ÒýÓÃconsole.writeline (sql)

Ìù³ö½á¹û£¬È»ºó°ÑÕâ¸öSQLÓï¾äÖ±½Óµ½ACCESSÖеIJéѯÖÐÊÔһϡ£Ëü»á¸æËßÄãʲô¶«Î÷²»¶ÔµÄ¡£


ÇëÏÈÌṩ½á¹û£¬·ñÔòÊÇÀË·Ñʱ¼ä£¡ Èç¹ûÄã¿ÉÒÔÈ·¶¨ÄãµÄSQLÓï¾äûÓÐÎÊÌ⣬ÄÇÒ²²»»á±¨´íÁË¡£

лл£¬ÎÒ¸Õ²Å×Ðϸ±È¶ÔÁËÒÔÏ£¬ÊÇ×Ö¶Îд´íÁËÒ»¸ö
лллллллллллллл

ÇëÎÊÔõô¸ø·Öѽ£¿£¿¡¢


Ïà¹ØÎÊ´ð£º

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ