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Ó¦ÓóÌÐòµÄ¿ª·¢Õߣ¬ÏÖÂÞÁÐÌø×ª·½·¨ºÍ´«Öµ·½Ê½¹©´ó¼Ò²Î¿¼£»ÒòΪÎÒ±¾Éí²ÎÓëµÄÏîÄ¿¹¦Ä ......
ËäÈ»Õâ¸ö¶«Î÷ºÜ»ù±¾£¬µ«ÊÇ×Ô¼ºÓÐʱºò»¹ÊǺܻìÂÒ£¬ËùÒÔ½ñÌì¾ÍССµÄÕûÀíÁËÏ£¬Ïȸø´ó¼Ò´øÀ´µÄÊÇÒ³ÃæµÄÌø×ªÎÊÌâ¡£
ÒÔÏÂÊÇËÄÖÖ ´ò¿ªÐÂÒ³ÃæµÄ·½·¨.
1. Ö±½ÓתÏòÐÂÒ³Ãæ,ÔÒ³Ãæ²»±£Áô
Response.Redirect("Webform6.aspx?id=1");
2. Ö±½ÓתÏòÐÂÒ³Ãæ,ÔÒ³Ãæ²»±£Áô
nServer.Transfer("Webform6.aspx?id=1",true);
3. ´ò¿ª ......
ÏîÄ¿Öо³£»áÓõ½°ÑexcelµÄÎļþÄÚÈݵ¼Èëµ½Êý¾Ý¿âÖеÄ,¸Õ¸Õ»¨Á˵ãʱ¼ä,×öÁ˸öÀý×Ó,»ù±¾ÉÏÄÜʵÏÖµ¼ÈëExcelºóÏÔʾµÄ¹¦ÄܰÉ,µ¼ÈëµÄexcelÎļþµÃÊÇxls,¼´ÊÇ2003µÄ.
´úÂë˼·ÈçÏÂ:Òª¶ÁÈ¡µÄexcelÎļþ±ØµÃµÃÊÇÔÚ±¾µØÓ²ÅÌ,ËùÒÔÒ»°ãÀ´Ëµ¶¼ÊÇÈÃÔ¶³ÌÓû§Ñ¡Ôñ×Ô¼ºÓ²ÅÌÉϵÄExcelÎļþ,È»ºó°ÑÓû§Ñ¡ÔñµÄÎļþÉÏ´«µ½±¾µØ· ......
+++ ÔÚWebÓ¦ÓóÌÐò¿ª·¢ÖУ¬»º´æ¶ÔÓ¦ÓóÌÐòÐÔÄܵÄÌá¸ßÓкܴó°ïÖú¡£±ÈÈ磬ÔÚͬһ¸öÓ¦ÓÃÖУ¬¾³£·¢Éú¶ÔͬһÊý¾Ý¡¢Âß¼¹¦ÄܺÍÓû§½çÃæµÄ¶à´ÎÇëÇó¡£µ±Óû§µÄ»ùÊýºÜ´óʱ£¬Èç¹ûÿ´ÎµÄÇëÇó¶¼½øÐд¦Àí£¬Ôò»áÏûºÄºÜ¶àµÄ·þÎñÆ÷×ÊÔ´¡£ÁíÍ⣬ÓÐʱ·þÎñÆ÷ÌṩµÄÊý¾Ý·þÎñ¿ÉÄÜ»áÒâÍâµØÍ£Ö¹£¬Ê¹Óûº´æ¼¼Êõ¿ÉÒÔÔÚÒ»¶¨Ê±¼äÄÚÈÔÈ»Õý³£µØÌṩ¶Ô×îÖ ......