ASP.NETÊý¾Ý°ó¶¨_µÚËÄÆª_ÓÃSqlDataSource¿Ø¼þ°ó¶¨_02
	
    
    
	+++ Ò³Ãæ´úÂëÈçÏ£º
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" PageSize="3"
    AutoGenerateColumns="true" DataKeyNames="username" DataSourceID="SqlDataSource1"
    AutoGenerateDeleteButton="True" 
    AutoGenerateEditButton="True" 
    AutoGenerateSelectButton="True">        
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="Data Source=ora9;User ID=scott;Password=tiger;Persist Security Info=True"
    ProviderName="System.Data.OracleClient" 
    SelectCommand="SELECT USERNAME, USERPWD from USERS" 
    UpdateCommand="UPDATE USERS SET USERPWD =:userpwd where USERNAME = :username" 
    DeleteCommand="DELETE from USERS where USERNAME =:username">
    <UpdateParameters>
        <asp:ControlParameter ControlID="GridView1" DefaultValue="username" Name="username"
            PropertyName="SelectedValue" />
        <asp:ControlParameter ControlID="GridView1" DefaultValue="userpwd" Name="userpwd"
            PropertyName="SelectedValue" />
    </UpdateParameters>
    <DeleteParameters>
        <asp:ControlParameter ControlID="GridView1" DefaultValue="" Name="username" PropertyName="SelectedValue" />
    </DeleteParameters>
</asp:SqlDataSource>
+++ ºǫ́´úÂëÈçÏ£º
(ÂÔ)
+++ ˵Ã÷£º
(1) Êý¾Ý¼¯°ó¶¨µ½¿Ø¼þÓжàÖÖ·½Ê½£»
(2) Ò»ÊÇÓÃÏñSqlDataSource¿Ø¼þ¡¢AccessDataSource¿Ø¼þ½øÐа󶨣»
(3) ¶þÊÇÓøü³éÏóµÄ¿Ø¼þ£¬ÈçObjectDataSource¿Ø¼þ°ó¶¨£»
(4) ÈýÊÇÓÃDataTable»òDataSet°ó¶¨£»
(5) Õâ
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    
±¾ÎĽéÉÜÁËASP.NET»ÃæÌø×ªµÄʵÏÖÒÔ¼°Æä´«ÖµÎÊÌâµÄ½â¾ö·½°¸¡£»ÃæÌø×ªºÍ´«ÖµÎÊÌ⣬һֱÒÔÀ´¶¼ÔÚÀ§ÈÅןոսӴ¥asp.net webÓ¦ÓóÌÐòµÄ¿ª·¢Õߣ¬Ï£Íû±¾ÎÄÄܶԳõѧÕßÃÇÓÐËù°ïÖú¡£
»ÃæÌø×ªºÍ´«ÖµÎÊÌ⣬һֱÒÔÀ´¶¼ÔÚÀ§ÈÅןոսӴ¥asp.net webÓ¦ÓóÌÐòµÄ¿ª·¢Õߣ¬ÏÖÂÞÁÐÌø×ª·½·¨ºÍ´«Öµ·½Ê½¹©´ó¼Ò²Î¿¼£»ÒòΪÎÒ±¾Éí²ÎÓëµÄÏîÄ¿¹¦Ä ......
	
    
        
    
    ÔÚa.aspxÌø×ªµ½b.aspx 
ͨ¹ýServer.Transfer("b.aspx") ÓëResponse.Redirect("b.aspx")µÄÇø±ð 
Èç¹ûÊÇͨ¹ýͨ¹ýServer.Transfer()ÔÚa.aspxÌø×ªµ½b.aspxµÄ£¬ÔòÔÚb.aspxÒ³Ãæ£¬¿ÉÒÔ²éÕÒµ½±£´æÔÚa.aspxÒ³ÃæÖÐµÄ ¿Ø¼þÖеÄÖµ£¬Èç¹ûÊÇResponse.Redirect(),ÔòµÃ²»µ½µ½a.aspxÒ³ÃæÖпؼþµÄÖµ¡£ 
Èç¹ûÊÇͨ¹ýServer.Transfer("b.aspx" ......
	
    
        
    
    ǰһ¶Îʱ¼ä×öÁËÄ£ÄâHttpÇëÇó£¬ÄÇôÎÒÃÇÓ¦¸ÃÔõô×ö¿ÉÒÔ×èÖ¹Óû§Ä£ÄâHttpÇëÇóÁË£¬ÔÚÕâÀïÍÆ¼öÒ»¸ö·½·¨£º¾ÍÊÇ·ÃÎÊʱ¼ä²îºÍ·ÃÎÊ´ÎÊý¡£ÎÒÃǰÑÊý¾Ý·ÃÎʵÄIP´æ·Åµ½Êý¾Ý¿â£¬ÒÔ±ãÎÒÃÇÒÔºó²é¿´¡£
Ê×ÏȽ¨Á¢Êý¾Ý±íºÍ´æ´¢¹ý³Ì
CREATE TABLE [dbo].[IPAccess](
    [IP] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NU ......
	
    
        
    
    ÔÚASP.NETÏÂʹÓûº´æ¼¼Êõ£¬ÎÒ¸öÈ˾õµÃÓÐÒÔϼ¸µã£º
1) Ìá¸ßÓ¦ÓóÌÐòÐÔÄܵÄÊÖ¶ÎÔÚÓ¦ÓóÌÐò¿ª·¢µÄ¸÷¸ö½×¶Î¶¼ÄÜÌåÏÖ³öÀ´£¬¼ÈÓÐСϸ½Ú£¬ÓÖÓдó·½Ïò¡£±ÈÈ磬±£Ö¤Éè¼ÆÒ»¸öºÃµÄÈí¼þÂß¼½á¹¹£»±£Ö¤Ê¹ÓÃÒ»¸öºÏÊʵÄÊý¾Ý½á¹¹£¬ÊǼ¯ºÏ¡¢Ê÷Ðνṹ£¬»¹ÊÇÁ´±í¡£·²ÊdzÌÐò¶¼ÊÇÓÉÊý¾Ý½á¹¹×é³ÉµÄ£¬Ò»Ì¸µ½Êý¾Ý½á¹¹¾ÍÒ»¶¨»áÉæ¼°µ½Êý¾ÝµÄ²åÈ롢ɾ ......
	
    
        
    
    +++ Ò³Ãæ´úÂëÈçÏ£º
<asp:Button ID="Button1" runat="server" Text="Ìí¼Ó¿ÕÐÐ" OnClick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="±£´æËùÓÐ" OnClick="Button2_Click" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="403px">
  ......