BYR Achieve · 镜像论坛

各位大虾，我在使用C# VS2010编程时，使用了gridview控件，可以显示数据库的表内容，但是却运行时页面虽然有EDIT按钮，点击后却没有任何反应，为什么? 我在show smart tag中，已经增加了edit按钮，在连接数据库时，也声称了相应的update语句，有谁知道为什么？贴出CS文档中的代码供参考。 <%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent"> </asp:Content> <asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent"> <h2> Welcome to ASP.NET! <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Customer No" DataSourceID="SqlDataSource2" onselectedindexchanged="GridView1_SelectedIndexChanged"> <Columns> <asp:BoundField DataField="Customer No" HeaderText="Customer No" ReadOnly="True" SortExpression="Customer No" /> <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" /> <asp:BoundField DataField="Address" HeaderText="Address" SortExpression="Address" /> <asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" /> <asp:BoundField DataField="District" HeaderText="District" SortExpression="District" /> <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" /> <asp:BoundField DataField="Contact Person" HeaderText="Contact Person" SortExpression="Contact Person" /> <asp:BoundField DataField="Contact Way" HeaderText="Contact Way" SortExpression="Contact Way" /> <asp:CommandField ShowEditButton="True" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TextDBConnectionString2 %>" DeleteCommand="DELETE FROM [Customer1] WHERE [Customer No] = @Customer_No" InsertCommand="INSERT INTO [Customer1] ([Customer No], [Name], [Address], [Country], [District], [City], [Contact Person], [Contact Way]) VALUES (@Customer_No, @Name, @Address, @Country, @District, @City, @Contact_Person, @Contact_Way)" SelectCommand="SELECT * FROM [Customer1]" UpdateCommand="UPDATE [Customer1] SET [Name] = @Name, [Address] = @Address, [Country] = @Country, [District] = @District, [City] = @City, [Contact Person] = @Contact_Person, [Contact Way] = @Contact_Way WHERE [Customer No] = @Customer_No"> <DeleteParameters> <asp:Parameter Name="Customer_No" Type="String" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="Customer_No" Type="String" /> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Address" Type="String" /> <asp:Parameter Name="Country" Type="String" /> <asp:Parameter Name="District" Type="String" /> <asp:Parameter Name="City" Type="String" /> <asp:Parameter Name="Contact_Person" Type="String" /> <asp:Parameter Name="Contact_Way" Type="String" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Address" Type="String" /> <asp:Parameter Name="Country" Type="String" /> <asp:Parameter Name="District" Type="String" /> <asp:Parameter Name="City" Type="String" /> <asp:Parameter Name="Contact_Person" Type="String" /> <asp:Parameter Name="Contact_Way" Type="String" /> <asp:Parameter Name="Customer_No" Type="String" /> </UpdateParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TextDBConnectionString %>" DeleteCommand="DELETE FROM [Customer1] WHERE [Customer No] = @Customer_No" InsertCommand="INSERT INTO [Customer1] ([Customer No], [Name], [Address], [Country], [District], [City], [Contact Person], [Contact Way]) VALUES (@Customer_No, @Name, @Address, @Country, @District, @City, @Contact_Person, @Contact_Way)" SelectCommand="SELECT * FROM [Customer1]" UpdateCommand="UPDATE [Customer1] SET [Name] = @Name, [Address] = @Address, [Country] = @Country, [District] = @District, [City] = @City, [Contact Person] = @Contact_Person, [Contact Way] = @Contact_Way WHERE [Customer No] = @Customer_No"> <DeleteParameters> <asp:Parameter Name="Customer_No" Type="String" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="Customer_No" Type="String" /> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Address" Type="String" /> <asp:Parameter Name="Country" Type="String" /> <asp:Parameter Name="District" Type="String" /> <asp:Parameter Name="City" Type="String" /> <asp:Parameter Name="Contact_Person" Type="String" /> <asp:Parameter Name="Contact_Way" Type="String" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Address" Type="String" /> <asp:Parameter Name="Country" Type="String" /> <asp:Parameter Name="District" Type="String" /> <asp:Parameter Name="City" Type="String" /> <asp:Parameter Name="Contact_Person" Type="String" /> <asp:Parameter Name="Contact_Way" Type="String" /> <asp:Parameter Name="Customer_No" Type="String" /> </UpdateParameters> </asp:SqlDataSource> </h2> <p> To learn more about ASP.NET visit <a href="http://www.asp.net" title="ASP.NET Website">www.asp.net</a>. </p> <p> You can also find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&clcid=0x409" title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>. </p> </asp:Content>

c# gridview 无法修改页面数据