ÔõÑùÓÃASP.NETʵÏָ߼¶ËÑË÷ - .NET¼¼Êõ / ASP.NET
ÒªÓÃASP.NET£¨C#ÓïÑÔ£©×öÒ»¸öѧÉúÐÅÏ¢¹ÜÀíµÄ¿Î³ÌÉè¼Æ£¬ÆäÖÐÒª²éѯÊý¾Ý¿â¡£
±ÈÈç²éѯ¿Î³ÌÊý¾Ý¿â£¬ÎÒÏëÓöà¸öDropDownListºÍ¶à¸öTextBox×éºÏ³ÉÒ»Ìõ½Ï¸´ÔÓµÄSQLÓï¾ä£¬DropDownListÓÃÀ´ÈÃÓû§Ñ¡Ôñ¡°»ò¡±¡¢¡°ÇÒ¡±¹ØÏµ£¬TextBoxÓÃÀ´ÊäÈë²éѯÄÚÈÝ¡£µ«ÊÔÁ˺ܾã¬×ÜÊDz»ÀíÏë¡£
²¼¾ÖÊÇÕâÑùµÄ£º
DropDownList_1 TextBox_1________________________(Òª²éѯµÄµÚÒ»¸ö×Ö¶Î)
DropDownList_2 TextBox_2________________________(Òª²éѯµÄµÚ¶þ¸ö×Ö¶Î)
DropDownList_3 TextBox_3________________________(Òª²éѯµÄµÚÈý¸ö×Ö¶Î)
¡¡
Ч¹ûͼÔÚÕâÀ
http://cid-cd3f5a1adc7796a2.skydrive.live.com/self.aspx/Images/Temp/Demo.jpg
°Ñ²éѯ½á¹û·ÅÔÚGridView¿Ø¼þÀï¡£
¾ÍÏñGoogleµÄ¸ß¼¶ËÑË÷»ò³¬ÐÇÊý×ÖͼÊé¹ÝÒ»Ñù¿ÉÒÔͬʱָ¶¨¶à¸öËÑË÷Ìõ¼þ¡£
²»ÖªµÀÔõÑùÀûÓÃÕ⼸¸ö¿Ø¼þÉú³ÉwhereÌõ¼þÓï¾ä½Ï¸´ÔÓµÄSQLÓï¾ä¡£{{
Ïà¹ØÎÊ´ð£º
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
¾ÍÊÇÒ»¸ö°´Å¥£¬µã»÷Ö®ºó´ò¿ª¶Ô»°¿ò£¬È»ºóѡȡͼƬ¡£¾ÍÕâÑùÉÏ´«¡£¡£
ÔõôʵÏÖ¡£ÔÚÍøÉÏËѵ½ÄÇô¶àµÄ´úÂ룬ȫÊǺܶàµÄÄÇÖÖ£¬²»ÖªµÀ£¬¿´²»ÏÂÈ¥¡£
ËùÒÔÔÚÕâÀïÏëÇë´ó¸ç´ó½ã°ï°ïæ¡£
ʹÓÃ×Ô´øµÄfileupload¿Ø¼þ¿ÉÒÔʵÏÖ ......
ÎÒ×î½ü×öÁËÒ»¸öÍøÕ¾ÊǹØÓÚ²úƷչʾµÄ ~ Õû¸öÍøÕ¾Í¼Æ¬¶¼Õ¼ÓÃÁËÒ»´ó°ë
ÕâÑùµÄ»°·ÃÎÊËٶȾͷdz£Âý ÓÐʲô°ì·¨¿ÉÒÔ½â¾öÂð£¿
Âé·³´ó¼Ò¶à¶à¸øµãÒâ¼û £¡ ÓÐʲô¾¡¹Ü˵
3Q´ó¼Ò
htmlÒ³Ãæ.
Õâ¸ö,¼ÈÈ»Ö÷Ò ......
½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡
¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡
Ö±½ÓÖ´ÐоÍÐÐÁË
exec ......
<table border= "0 " cellspacing= "0 " cellpadding= "0 ">
<BH_CHANNELS ID= "OWNER " CHILDTYPE= "aaa " ......