利用commandfield控件更新数据库信息
设置SqlDataSource控件的UpdateCommand属性,并设置其相应的 UpdateParamenters标签 和构造SQL语句的参数
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:worldConnectionString %>" ProviderName="<%$ ConnectionStrings:worldConnectionString.ProviderName %>"
SelectCommand="SELECT * FROM tb where CountryCode='CHN'"
UpdateCommand=" update tb set ID=@ID, Name=@Name, CountryCode=@CountryCode, Population=@Population where ID=@ID">
<UpdateParameters>
<asp:Parameter Name="ID" Type="String" />