Asp.net µÄButton_ClicKʼþ
ÔÚʼþ
C# code:
protected void Button1_Click(object sender, EventArgs e)
{
string strupdate = "update S set SN = '" + txt_SN.Text + "',SD = '" + txt_SD.Text + "',SA = '" + txt_SA.Text + "' where S#='" + Request.QueryString["SNO"] + "'";
CC.ExecSQL(strupdate);
Response.Redirect("Student.aspx");
}
Öеã»÷°´Å¥Êý¾Ý¿â¸ù±¾¾Í²»¸üРÕâÊÇÎªÊ²Ã´ÄØ£¿
ÎÒʹÓÃÁËÑéÖ¤¿Ø¼þ
sql Óï¾äдµÄÓÐÎÊÌâ
(1)´úÂëÓÐûÓб»Ö´ÐÐ
(2)SQLÊÇ·ñÕýÈ·
ÒÔºóÅöµ½Õâ¸öÎÊÌâµ÷ÊÔ°É
1.ʹÓÃÁËÑéÖ¤¿Ø¼þ¡£¾Í¼ì²éÊÇ·ñÑéÖ¤³É¹¦»¹Ã»ÓиüÐÂ
2.µ÷ÊÔ°ÉSQL£¨strupdate £©Óï¾äÌá³öÀ´Äõ½SQL»·¾³ÏÂÈ¥ÔËÐÐʱ·ñÄܹ»Í¨¹ý
3.CC.ExecSQL(strupdate);Ó¦¸ÃÒªÅжÏÏ·µ»ØÖµ..
4.Response.Redirect("Student.aspx");//¿´這Щ´úÂëÈç¹ûÑé֤ͨ¹ýµÄÇé¿ö϶¼»áÌø×ªÒ³ÃæÈç¹ûÃ»Ìø×ª»Øµ½1.
sqlÓï¾ä¼ì²éÒ»ÏÂ,µ÷ÊÔ¸ú×Ù,¿´¿´CC.ExecSQL(strupdate)ÀïÃæµÄstrupdateÕâ¸ö×Ö·û´®ÊÇ·ñÕýÈ·
Ê×Ï顄 SQLÓï¾ä´øÈë¹Ì¶¨Öµ¿´¿´ÓÐÎÊÌâÂð£¿Èç¹ûûÓоÍ˵Ã÷ÄãµÄExecSQL£¨£©·½·¨ÓÐÎÊÌâÁË£¬×Ðϸ¼ì²éһϰɡ£×£ÄãºÃÔË£¡
¸÷λ
ÀàºÍSQLÓï¾ä¶¼Ã»´í£¬ÎÒ±£Ö¤
ÎÒÖ»ÊÇ·¢ÏÖµã»÷°´Å¥ºóIsPostBac
Ïà¹ØÎÊ´ð£º
°ÑÒµÎñ²ãµÄ¶¼Ð´ÔÚdllÎļþÖÐÁË£¬ÏÖÔÚÏëÒªÐ޸쬴ó¼Ò¶¼ÓÃʲô¹¤¾ß´ò¿ª£¿
ÓÃvisual studio×Ô´øµÄ ildasm¿ÉÒÔÂð£¿
ÆÚ´ý¸ßÊÖ
LZºÃÀ÷º¦
Ó÷´±àÒëÈí¼þ
ÎÒÓÃReflectorÖ»ÄÜ¿´£¬²»Äܸİ¡£¿
ÓÐÃ ......
±¾ÈËĿǰÓöµ½Ò»¸öÄÑÌ⣬Çë¸÷λ¸ßÊÖ¡¢´óÏÀ°ï°ïæ¡£
ÎÒµ¥»÷Ò»¸ö°´Å¥Ê±Òª°ÑgridviewÖеÄÊý¾ÝÒ»¸öÒ»¸öµÄÈ¡³ö²¢°Ñ¶ÔÓ¦²ÎÊý´«µÝ¸øÇ°Ì¨µÄjs¡£
ÎÒÊÔÁ˼¸ÖÖºǫ́µ÷ǰ̨µÄ·½Ê½¶¼Ã»Óгɹ¦£¬ËùÒÔÇë´óÏÀÃǰï°ïСµÜ¡£
лл¡£
²» ......
µ÷ÕûÁËÕâÀÄÇÀï³öÎÊÌâ¡£
ÓÐûÓÐʲôºÃµÄ·½·¨£¬Ïñµ÷Õû¶Ô»°¿òÒ»Ñù£¿£¿£¿£¿
ÕÒ¸öרÃÅ×öÒ³ÃæµÄ
ÔÚdreamweaverÀïµ÷¡£¡£¡£Ò²¿ÉÒÔÖ±½Ó¿ØÖÆHTML´úÂë
ȷʵʹ¿à ¸ÐͬÉíÊÜѽ
¹þ¹þ ¼á¾ö·¹ý¡£
ÓÃDW°É£¬VS¸ãÉè¼Æ ......
´ÓÊý¾Ý¿â»ñÈ¡Êý¾Ý·Åµ½ÏÂÀ¿ò£¬³õʼֵÉèΪȫ²¿¡£
¡°³õʼֵÉèΪȫ²¿¡±£¬ÔõôʵÏÖ£¬¶øÇÒ²»ÓëÊý¾Ý¿âÀïµÄÊý¾Ý²úÉú³åÍ»¡£¡£
DropDownList.Items.Add(new ListItem("È«²¿","Ëæ±ãÒ»¸öÖµ"));
DropDo ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......