<asp:SqlDataSource ID="Post_Article_SqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:cccdbaccessConnectionString %>"
ProviderName="<%$ ConnectionStrings:cccdbaccessConnectionString.ProviderName %>"
SelectCommand="SELECT [Artcle_ID], [Artcle_Pic], [Artcle_Topic], [Artcle_Body], [Artcle_Author], [Artcle_CreatTime], [Artcle_Sum], [Artcle_Hits], [Artcle_LastTime], [Artcle_LastOrder], [Artcle_Parent], [Artcle_WhichTopic] FROM [BBS_Article] WHERE ([Artcle_ID] = ?)"
UpdateCommand ="Update [BBS_Article] set [Artcle_Topic]=@Artcle_Topic,[Artcle_Body]=@Artcle_Body,[Artcle_Author]=@Artcle_Author,[Artcle_Pic]=@Artcle_Pic,[Artcle_LastTime]=@Artcle_LastTime,[ipfrom]=@ipfrom WHERE ([Artcle_ID] = @Artcle_ID)">
<SelectParameters>
<asp:QueryStringParameter Name="Artcle_ID" QueryStringField="id" Type="Int16" />
</SelectParameters>
<UpdateParameters >
<asp:QueryStringParameter Name ="Artcle_ID" QueryStringField ="id" Type ="Int16" />
<asp:Parameter Name ="Artcle_Topic" Type ="String"/>
<asp:Parameter Name ="Artcle_Body" Type ="String" />
<asp:Parameter Name ="Artcle_Author" Type ="string" />
<asp:Parameter Name="Artcle_Pic" Type="String" />
<asp:Parameter Name="Artcle_LastTime" Type="DateTime" />
<asp:Parameter Name ="ipfrom" Type ="string" />
</UpdateParameters>
</asp:SqlDataSource>
注意:updatecommand命令的赋值字段顺序和updateparameters参数中的排列顺序要一致,不然会产生字段更新错位。