📄 default.aspx

📁 水晶报表详细资料水晶报表详细资料水晶报表详细资料

💻 ASPX

字号:

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>示例20_04</title>
</head>
<body style="text-align: center">
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DB_ADONETConnectionString %>"
            SelectCommand="SELECT * FROM [t_People]" 
            UpdateCommand="UPDATE [t_People] SET [tb_PName] = @tb_PName, [tb_PSex] = @tb_PSex WHERE [tb_PID] = @tb_PID">
            <UpdateParameters>
                <asp:Parameter Name="tb_PName" Type="String" />
                <asp:Parameter Name="tb_PSex" Type="String" />
                <asp:Parameter Name="tb_PID" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
    
    </div>
        <asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
            DataKeyNames="tb_PID" DataSourceID="SqlDataSource1" Height="50px" Width="360px">
            <Fields>
                <asp:BoundField DataField="tb_PID" HeaderText="tb_PID" ReadOnly="True" SortExpression="tb_PID" />
                <asp:BoundField DataField="tb_PName" HeaderText="tb_PName" SortExpression="tb_PName" />
                <asp:BoundField DataField="tb_PSex" HeaderText="tb_PSex" SortExpression="tb_PSex" />
                <asp:CommandField ShowEditButton="True" />
            </Fields>
            <HeaderTemplate>
                <strong>
                <span>UpdateCommand属性与UpdateParameters属性</span> </strong>
            </HeaderTemplate>
        </asp:DetailsView>
    </form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -