SQLDataSource控件与CommandField控件搭配更新数据库

 利用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" />