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.´ø²ÎÊý´«µÝ
Óŵã:ʹÓ÷½±ã
ȱµã:°²È«ÐÔµÍ,Êʺϴ«µÝ¼òµ¥ÀàÐ͵ĶÔÏó,±ÈÈçÊý×Ö.×Ö·û.µ«¶Ô¶ÔÏó.Êý×éµÈ²»ºÏÊÊ´«µÝ.
Ó¦ÓÃ:
a.°²È«ÐÔ²»¸ß,Ó¦¶Ô·½Ê½:¶Ô´«µÝµÄÖµ½øÐмÓÃÜ.
b.´«µÝ¼òµ¥ÀàÐ͵ĶÔÏó.Ó¦¶Ô·½Ê½:ÔÚ´«µÝҳͨ¹ý¼òµ¥ÀàÐͶÔÏó¸ø³ö±êʶ,ÔÚ ......
дÁËÒ»¸ö´´½¨ÐéÄâĿ¼µÄ WebService ³ÌÐò£¬ÔÚ²âÊÔÔËÐÐʱ¿ÉÒԳɹ¦´´½¨£¬µ«ÆäËü³ÌÐòµ÷ÓÃʱ£¬ÌáʾûÓÐȨÏÞ´´½¨¡£
²éÁËһЩ×ÊÁÏ£¬ÔÚweb.configÀïÃæµÄ<system.web>ºó¼ÓÉÏÅäÖãº
<identity impersonate="true" userName="²Ù×÷ϵͳÓû§Ãû" password="Óû§¶ÔÓ¦µÄÃÜÂë" />
ÎÊÌâ½â¾ö¡£Ìش˼Ǽ£¬È¨ ......
1¡¢aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TransferMoney.aspx.cs" Inherits="BtmsWebApp.report.TransferMoney" MasterPageFile="~/ReportPage.master" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d5 ......
ÔÚASP.NETÏÂʹÓûº´æ¼¼Êõ£¬ÎÒ¸öÈ˾õµÃÓÐÒÔϼ¸µã£º
1) Ìá¸ßÓ¦ÓóÌÐòÐÔÄܵÄÊÖ¶ÎÔÚÓ¦ÓóÌÐò¿ª·¢µÄ¸÷¸ö½×¶Î¶¼ÄÜÌåÏÖ³öÀ´£¬¼ÈÓÐСϸ½Ú£¬ÓÖÓдó·½Ïò¡£±ÈÈ磬±£Ö¤Éè¼ÆÒ»¸öºÃµÄÈí¼þÂß¼½á¹¹£»±£Ö¤Ê¹ÓÃÒ»¸öºÏÊʵÄÊý¾Ý½á¹¹£¬ÊǼ¯ºÏ¡¢Ê÷Ðνṹ£¬»¹ÊÇÁ´±í¡£·²ÊdzÌÐò¶¼ÊÇÓÉÊý¾Ý½á¹¹×é³ÉµÄ£¬Ò»Ì¸µ½Êý¾Ý½á¹¹¾ÍÒ»¶¨»áÉæ¼°µ½Êý¾ÝµÄ²åÈ롢ɾ ......