sql²éѯתΪlinq²éѯ
ÏÖÔÚÓÐÕâÑùÒ»Ìõ²éѯÓï¾ä
delete from table1 where id in(1,2,3,4)
Èç¹ûʹÓÃlinqÀ´¶ÔʵÌå½øÐвÙ×÷ÊÇÔõôдµÄÄØ£¿
ÆÚ´ý½â¾ö¡£
Áí×£´ó¼Ò¹úÇì¿ìÀÖ
×Ô¼º¶¥ÉÏÈ¥
¶ÔLing²»ÊìϤŶ
¸Ð¾õÉϲ»ÁË´óÌ¨Ãæ
лл2Â¥¡£
ÔÙ¶¥ÉÏÈ¥
Any ÓÃÓÚÅжϼ¯ºÏÖÐÊÇ·ñÓÐÔªËØÂú×ãijһÌõ¼þ
All ÓÃÓÚÅжϼ¯ºÏÖÐËùÓÐÔªËØÊÇ·ñ¶¼Âú×ãijһÌõ¼þ
Contains ÓÃÓÚÅжϼ¯ºÏÖÐÊÇ·ñ°üº¬ÓÐÄ³Ò»ÔªËØ
²Î¿¼
LSÒѾ·Ç³£ÏêϸµÄ°ïÖúµ½ÄãÁË£¬¹Ø¼üÊÇÄã×Ô¼ºÔõôѧϰÁË£¡
²»»álinq
¶¥ÏÂ
up
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
PBÖпª·¢µÄ¡£
DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)
string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......
ÎÒÏëʹÓÃSql±à¸öС³ÌÐò£¬¾ÍÊÇÅж¨Ò»¸ö×Ö·û´®³öÏÖÁ˼¸´ÎÖ¸¶¨×Ö·û£»
ÀýÈçÔÚstringÐÍ¡°6+4+8+2¡±ÖУ¬ÎÒÐèÒªÅж¨³öÏÖÁ˼¸¸ö¡°+¡±£»²¢ÇÒʵÏÖ
if £¨³öÏÖ3´Î£©
then
¡¡¡¡¡¡£¨Òý·¢Ê¼þ£©£»
......