ویرایش رکورد

[imanshirani]

نميدونم چرا اين کد رکوردهاي جدول آپ ديت (ويرايش) نمي کنه مشکل از کجاست .




<asp:SqlDataSource ID="SqlDataSourcePostEdit" runat="server"
ConnectionString="<%$ ConnectionStrings:MyArtsBox %>"
SelectCommand="SELECT * FROM [MyArtsBox_News] WHERE ([IDNews] = @IDNews)"
ConflictDetection="CompareAllValues"
OldValuesParameterFormatString="original_{0}"
UpdateCommand="UPDATE [MyArtsBox_News] SET [Picture] = @Picture, [Subject] = @Subject, [Note] = @Note, [Text] = @Text WHERE [IDNews] = @original_IDNews">
<SelectParameters>
<asp:ControlParameter ControlID="GridViewPostWeblog" Name="IDNews" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="DateTime" Type="DateTime" />
<asp:Parameter Name="Username" Type="String" />
<asp:Parameter Name="Picture" Type="String" />
<asp:Parameter Name="Subject" Type="String" />
<asp:Parameter Name="Note" Type="String" />
<asp:Parameter Name="Text" Type="String" />
<asp:Parameter Name="Visit" Type="Int32" />
<asp:Parameter Name="original_IDNews" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
<asp:DetailsView ID="DetailsViewEditPost" runat="server" DataSourceID="SqlDataSourcePostEdit" AutoGenerateRows="False" DefaultMode="Edit" Height="50px" Width="125px" CssClass="TableinsertDetails">
<Fields>
<asp:BoundField Visible="False" ReadOnly="True" HeaderText="IDNews" InsertVisible="False" DataField="IDNews" SortExpression="IDNews" />
<asp:BoundField ReadOnly="True" HeaderText="DateTime" DataField="DateTime" SortExpression="DateTime" />
<asp:BoundField ReadOnly="True" HeaderText="Username" DataField="Username" SortExpression="Username" />
<asp:BoundField HeaderText="Subject" DataField="Subject" SortExpression="Subject" />

<asp:TemplateField HeaderText="Note">
<EditItemTemplate>
<asp:TextBox ID="Note" runat="server" Text='<%# Bind("Note") %>' Width="350" Rows="5" TextMode="MultiLine"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="Text">
<EditItemTemplate>
<asp:TextBox ID="Text" runat="server" Text='<%# Bind("Text") %>' Width="350" Rows="10" TextMode="MultiLine"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>

<asp:TemplateField SortExpression="Picture" HeaderText="Picture">
<EditItemTemplate>
<asp:TextBox ID="Picture" runat="server" Text='<%# Bind("Picture") %>'></asp:TextBox><br />
<wu:PictureUpload ID="PictureUpload" runat="server" UploadImageType="Weblog" OnFileUploaded="FileUploaded"></wu:PictureUpload>
</EditItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Fields>
</asp:DetailsView>