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

c/sÖÐÓù˼°µ½SQL×¢Èëô - .NET¼¼Êõ / C#

¿Í»§¶ËÊÇÕâôдµÄ´úÂë
selname ="select top 20 num,name,kind,address,price,phone,title,picture,time from shangpin where name='" + comboBox2.Text + "' order by time desc"
È»ºó°Ñselname·¢Ë͸ø·þÎñÆ÷,·þÎñÆ÷ÔÙ¸ù¾ÝÕâ¸ö×Ö·û´®È¥²éѯ,°Ñ²éѯ½á¹ûÒÔdatatable·¢»ØÀ´.

ÄÇÕâ¸öÖ±½ÓдÔÚ¿Í»§¶ËÈ¥²Ù×÷Êý¾Ý¿â²»¾ÍÐÐÁË
ºÎ±ØÔÙÈ÷þÎñÆ÷¶ËÅÜÒ»±éÈ¥Ö´ÐÐÄØ£¿
Õâ²»ÀË·Ñ×ÊÔ´Âï

Ìá¸ß°²È«ÐÔ£¿£¿



µ±È»ÁË£¬Ò²Òª¿¼ÂÇ£¬²»¹ýÑéÖ¤¿ÉÒÔÔÚclinet¶Ë×ö¡£

ÓòÎÊý,¿ÉÒÔ·ÀÖ¹sql×¢Èë

ÒýÓÃ
µ±È»ÁË£¬Ò²Òª¿¼ÂÇ£¬²»¹ýÑéÖ¤¿ÉÒÔÔÚclinet¶Ë×ö¡£

Ôõô×öÑéÖ¤?



good good study,day day up

Ìõ¼þ´«Öµ½øÐвÎÊý»¯


ÈçÉÏÃæËù˵£º°²È«¸ßЧ¡£

ÓÐÈË˵LINQ¾Í¿ÉÒÔ·ÀÖ¹SQL×¢Èë
²»ÖªµÀÊDz»ÊÇÕæµÄ
¸öÈËÈÏΪLINQºÜºÃ¡¢ºÜÇ¿´ó

¼ÈÈ»ÊÇC/SÄã²»ÓÃDB ClientÈ´·¢ËÍʲôSQLÓï¾ä²»ÊdzԱ¥Á˳ŵÄÂð...

ÒýÓÃ
¼ÈÈ»ÊÇC/SÄã²»ÓÃDB ClientÈ´·¢ËÍʲôSQLÓï¾ä²»ÊdzԱ¥Á˳ŵÄÂð...

ÎÒ²ËÄñ,ÎÊÏÂDB ClientÊÇʲô?

»Ø¸´ÄÚÈݲ»ÄÜΪ¿Õ,ÇëÊäÈë»Ø¸´£¡

ÒýÓÃ
¿Í»§¶ËÊÇÕâôдµÄ´úÂë
selname ="select top 20 num,name,kind,address,price,phone,title,picture,time from shangpin where name='" + comboBox2.Text + "' order by time desc"
È»ºó°Ñselname·¢Ë͸ø·þÎñÆ÷,·þÎñÆ÷ÔÙ¸ù¾ÝÕâ¸ö×Ö·û´®È¥²éѯ,°Ñ²éѯ½á¹ûÒÔda¡­¡­
ÊDz»ÊÇ·¢Ë͸ö¡°delete from shangpin where name like 'A%'¡


Ïà¹ØÎÊ´ð£º

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔÏ°¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»ÁË°¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ