Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

sqlÓï¾äÆæ¹ÖÎÊÌâ

ÎÒµÄsqlÓï¾äÈçÏ£º

select a.productname,a.sell_price,b.id from umc_product a left join umc_product_image b on a.id=b.id where a.id='1034';

°Ñ½á¹û·ÅÔÚ¸ö$arrÀÕâʱ$arr[0]ÓÐÖµ£¬$arr[1]ÓÐÖµ£¬µ«$arr[2]Àïûֵ,ÓÃ$arr['id']Ò²Äò»µ½¡£

µ«ÊÇsqlÓï¾ä¸Äµ½ÈçÏÂ,$arr[2]Àï¾ÍÓÐÖµÁ ......

¹ØÓÚsql×¢Èë

SqlCommand cmd = new SqlCommand("select * from WARE where warename='" + TextBox1.Text + "'", conn);  Õâ¸ö¿ÉÒÔSQL×¢È룬Ã÷°×¡£


//SqlCommand cmd = new SqlCommand("jian", conn);

     
        //cmd.Comma ......

Çë½ÌÒ»¸ösqlÓï¾ä

µÚÒ»¸ö±í£º
jc1    jc2  jc3  ysbh
2.2    2.3  2.5  0001


µÚ¶þ¸ö±í£º
jc4    jc5  jc6  ysbh
a      b    c    0002


ysbhÏà¹ØÁªµÄ±íÊÇ£º
ysbh  ysxm
0001  Õ ......

ÇóÒ»¸ömysql ×ֶβð·ÖËÑË÷sqlÓï¾ä

±êÌâ½²²»Çå³þ¹þ¡­¡­¡­¡­


Êý¾Ý´æ´¢¸ñʽ

×Ö¶ÎÃû      Êý¾Ý
year      2009
month      11
days      |2:40|3:23|4:21|  ......    (½âÊÍ,Ç°ÃæÊÇÈÕÆÚ£¬ºóÃæÊǼ۸ñ  ÈÕÆÚ:¼Û¸ñ)

ÎÒÏë²»³öÆäËûµÄÊý¾Ý½á¹¹Á ......

SQL·þÎñÆ÷Êý¾Ý¿ìËÙÏÂÔØµ½±¾µØACCESS

DELPHI
SQL
ACCESS

  ÎÊÌâ±³¾°£º¿¼ÊÔ³ÌÐò£¬ÓÉSQL·þÎñÆ÷£¨·Ç±¾µØ£©ÏÂÔØÊý¾Ýµ½±¾µØµÄACCESS
  ÎÊÌâ´úÂ룺
    sfield := 'ktid,tkid,ktdl,ktxl,ktnr,A,B,C,D,E,F,G,H,TA,TB,TC,TD,TE,TF,TG,TH,KTDA,KTJY';
    slj := ExtractFilePath(ParamStr(0)) + 'da ......

ASP.NET & SQL server 2000µÄ³õѧÎÊÌâ

ÎÒÊdzõѧÕߣ¬ÏëÎÊһϡ££¨ÒÔÏÂÃèÊö»òÐíÓÐЩµØ·½ºÜ²»×¨Òµ£¬Â©¶´°Ù³ö£¬Çë¼ûÁÂÖ¸³ö£¡£©


ÎÒÏÖÔÚÓÐÒ»¸ö±ðÈË×öµÄÍøÕ¾£¨Ä¬ÈÏÍêÈ«Õý³££¬ÒÔǰÕý³£ÔËÐйý£¬¾ÍÊÇÕâ´Î֨װÁËwindows server 2003£¬ËùÒÔ֮ǰµÄûÁË£©£¬²¢²»ÊÇ¿ª·¢ÖУ¬ÎÒÒª×öµÄÊǰÑÍøÕ¾¡¢·þÎñÆ÷µÈÖØÐ½¨Á¢ÆðÀ´¡£


ÍøÕ¾Ê¹Óà asp.net £¨C#£©Ð´µÄ£¬Êý¾Ý¿â ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [391] [392] [393] [394] 395 [396] [397] [398] [399] [400]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ