ASP.NET Web Form GridView DetailsView Query Edit

最後更新：2018-12-06 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

<%@ Page language="C#" validaterequest="false" enableviewstate="false"%><!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>        <title>            DetailsView GridView Query Edit Example        </title>        <meta name="generator" content="editplus" />        <meta name="author" content="" />        <meta name="keywords" content="" />        <meta name="description" content="" />    </head><body>    <form id="form1" runat="server">            <asp:DetailsView                ID="DetailsView1"                runat="server"                AutoGenerateRows="false"                DefaultMode="Insert"                DataKeyNames="RowID"                DataSourceID="SqlDataSource1"            >                <Fields>                    <asp:BoundField                        DataField="Field01"                        HeaderText="Field01"                    />                    <asp:BoundField                        DataField="Field02"                        HeaderText="Field02"                    />                    <asp:BoundField                        DataField="Field03"                        HeaderText="Field03"                    />                    <asp:TemplateField                        ShowHeader="False"                    >                        <InsertItemTemplate>                            <asp:Button                                ID="Button1"                                runat="server"                                CausesValidation="True"                                 CommandName="Insert"                                Text="插入"                                OnClientClick="return confirm('add?')"                            />                            <input type="reset" />                        </InsertItemTemplate>                    </asp:TemplateField>                </Fields>            </asp:DetailsView>        <BR>        Field01:         <asp:TextBox            ID="TextBox1"            runat="server"        />        <asp:Button            ID="Button1"            runat="server"            Text="查詢"        />        <BR>        <asp:gridview            id="GridView1"             datasourceid="SqlDataSource1"             autogeneratecolumns="true"            allowpaging="true"            pagesize="20"            datakeynames="RowID"            runat="server"        >            <Columns>                <asp:TemplateField                    ShowHeader="False"                >                    <ItemTemplate>                        <asp:LinkButton                            ID="LinkButton1"                            runat="server"                            CausesValidation="False"                             CommandName="Delete"                            Text="刪除"                            OnClientClick="return confirm('delete?')"                        />                    </ItemTemplate>                </asp:TemplateField>                <asp:TemplateField                    ShowHeader="False"                >                    <EditItemTemplate>                        <asp:LinkButton                            ID="LinkButton2"                            runat="server"                            CausesValidation="True"                             CommandName="Update"                            Text="更新"                            OnClientClick="return confirm('update?')"                        />                        &nbsp;                        <asp:LinkButton                            ID="LinkButton3"                            runat="server"                            CausesValidation="False"                             CommandName="Cancel"                            Text="取消"                        />                    </EditItemTemplate>                    <ItemTemplate>                        <asp:LinkButton                            ID="LinkButton4"                            runat="server"                            CausesValidation="False"                             CommandName="Edit"                            Text="編輯"                        />                    </ItemTemplate>                </asp:TemplateField>            </Columns>        </asp:gridview>        <!-- to do -->        <asp:sqldatasource            id="SqlDataSource1"            selectcommand="execute xsp_TableName_SelectAll @Field01"            updatecommand="execute xsp_TableName_UpdateByRowID @RowID,@Field01,@Field02,@Field03"            insertcommand="execute xsp_TableName_Insert @Field01,@Field02,@Field03"            deletecommand="execute xsp_TableName_DeleteByRowID @RowID"            connectionstring="Application Name=AppTest;Integrated Security=SSPI;Persist Security Info=False;Data Source=SQLServerName;database=DataBaseName"            runat="server"        >            <SelectParameters>                <asp:ControlParameter                    ControlID="TextBox1"                    Name="Field01"                    PropertyName="Text"                    DefaultValue=" "                    DbType="String"                />            </SelectParameters>        </asp:sqldatasource>    </form></body></html>

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More