ÇëÎÊÕâ¸ö´íÎóÊÇÔõô»ØÊ°¡£¿°ï°ïæ £¬Ð»Ð»
¡°/WebSite¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--------------------------------------------------------------------------------
ÁÐÃû '%°ÙºÏ%' ÎÞЧ¡£
ÁÐÃû '%°ÙºÏ%' ÎÞЧ¡£
ÁÐÃû '%°ÙºÏ%' ÎÞЧ¡£
ÁÐÃû '%°ÙºÏ%' ÎÞЧ¡£
˵Ã÷: Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
Òì³£ÏêϸÐÅÏ¢: System.Data.SqlClient.SqlException: ÁÐÃû '%°ÙºÏ%' ÎÞЧ¡£
ÁÐÃû '%°ÙºÏ%' ÎÞЧ¡£
ÁÐÃû '%°ÙºÏ%' ÎÞЧ¡£
ÁÐÃû '%°ÙºÏ%' ÎÞЧ¡£
Ô´´íÎó:
ÐÐ 608: //Ö´Ðйý³Ì
ÐÐ 609: myConn.Open();
ÐÐ 610: myCmd.ExecuteNonQuery();
ÐÐ 611:
ÐÐ 612: SqlDataAdapter da = new SqlDataAdapter(myCmd);
Ô´Îļþ: e:\4.1\WebSite\App_Code\ManagerClass.cs ÐÐ: 610
create proc Proc_SearchGoodsInfo
(@keywords varchar(50))
as
declare
@sql nvarchar(1024)
set @sql='select g.FlowerID from Flower as g join Class c on
(g.ClassID=c.ClassID) where
(FlowerID like "%'+CONVERT(NVARCHAR(50),@keywords)
+'%" or FlowerName like "%'+CONVERT(NVARCHAR(50),@keywords)
+'%" or ClassName like "%'+CONVERT(NVARCHAR(50),@keywords)
ÎÒÓÃasp.net¿ª·¢wapÕ¾µã£¬Íê³ÉºóÈ¥http://validator.w3.org/ÕâÀïÑéÖ¤ÎÒµÄWapÒ³ÃæÊÇ·ñ±ê×¼£¬ÆäËüÎÊÌâ¶¼¸ÄºÃÁË£¬
¾ÍÊ£ÕâÒ»¸ö´íÎóÁË£¬°´×ÖÃæÒâ˼Àí½âÊÇ˵nameÊôÐÔÒÑ´æÔÚ£¬ÀàËÆÕâÑùµÄ´íÎó»¹Óв»ÄÜÓÃborder ,align,sizeµ ......