gridview 中更新有错。

Question

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DB %>" 
            DeleteCommand="DELETE FROM [car] WHERE [carId] =@carId"
            SelectCommand="SELECT [carId], [carName], [carNum], [carYiyong], [carYushu] FROM [car]"
            UpdateCommand="UPDATE [car] SET [carName]=@carName,[carNum]=@carNum,[carYiyong]=@carYiyong WHERE [carId]=@carId">
           </asp:SqlDataSource>
删除都能够实现，为什么更新就不行，请高手解答！

Answer 1

Updating事件里面有没有问题，？
<UpdateParameters>
里面有写么？
</UpdateParameters>

Answer 2

参数写没有？
 <asp:SqlDataSource
          id="SqlDataSource1"
          runat="server"
          ConnectionString="<%$ ConnectionStrings:MyNorthwind%>"
          SelectCommand="SELECT EmployeeID, LastName, Address FROM Employees"
          UpdateCommand="UPDATE Employees SET Address=@Address WHERE EmployeeID=@EmployeeID">
          <UpdateParameters>
              <asp:ControlParameter Name="Address" ControlId="TextBox1" PropertyName="Text"/>
              <asp:ControlParameter Name="EmployeeID" ControlId="DropDownList1" PropertyName="SelectedValue"/>
          </UpdateParameters>
      </asp:SqlDataSource>

Answer 3

GridView_demo