but in code page i cannot seem to update messages table through Dataview source code:
Dim dv As DataView = CType(SqlCorrespondance.Select(DataSourceSelectArguments.Empty), DataView)
If Not dv Is Nothing Then
dv.AllowNew = True
Dim newRow As DataRowView = dv.AddNew()
newRow.BeginEdit()
newRow.Item("PRODUCTID") = ProdID
newRow.Item("RefItemID") = RefItemID
newRow.Item("MessageID_Reply") = MessageID.Value
newRow.Item("subject") = lblSubject.Text
newRow.Item("body") = Server.HtmlDecode(TxtReply.Text)
newRow.Item("datentime") = Date.Now
newRow.EndEdit()
End If
RepCorrespondance.DataSource = dv
If there is no error in your codes, the only possible reason is that you forget to call DataBind() method for the repeater control.
Add the below line of codes after the DataSource line
RepCorrespondance.DataSource = dv
RepCorrespondance.DataBind()
I tested your codes and could not understand the rationale of your design.
You don't store the new row into the database? Just directly display it?
The common implementation would be inserting the new row to the database and then select the updated result from database and bind the data to the controls.
Could you please check if you need to modify the current codes?
Member
272 Points
846 Posts
SQL DataView will not update records?
Oct 18, 2020 02:19 PM|peterthegreat|LINK
i have declared SQLdatasource as such:
<asp:SqlDataSource ID="SqlCorrespondance" runat="server" DataSourceMode="DataSet" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT * FROM [Messages] WHERE ([MessageID_Reply] = @MessageID_Reply2)"> <SelectParameters> <asp:Parameter Name="MessageID_Reply2" Type="Int64" /> </SelectParameters> </asp:SqlDataSource>but in code page i cannot seem to update messages table through Dataview source code:
Dim dv As DataView = CType(SqlCorrespondance.Select(DataSourceSelectArguments.Empty), DataView) If Not dv Is Nothing Then dv.AllowNew = True Dim newRow As DataRowView = dv.AddNew() newRow.BeginEdit() newRow.Item("PRODUCTID") = ProdID newRow.Item("RefItemID") = RefItemID newRow.Item("MessageID_Reply") = MessageID.Value newRow.Item("subject") = lblSubject.Text newRow.Item("body") = Server.HtmlDecode(TxtReply.Text) newRow.Item("datentime") = Date.Now newRow.EndEdit() End If RepCorrespondance.DataSource = dvContributor
2170 Points
642 Posts
Re: SQL DataView will not update records?
12 hours, 1 minute ago|Sean Fang|LINK
Hi peterthegreat,
If there is no error in your codes, the only possible reason is that you forget to call DataBind() method for the repeater control.
Add the below line of codes after the DataSource line
RepCorrespondance.DataSource = dv RepCorrespondance.DataBind()I tested your codes and could not understand the rationale of your design.
You don't store the new row into the database? Just directly display it?
The common implementation would be inserting the new row to the database and then select the updated result from database and bind the data to the controls.
Could you please check if you need to modify the current codes?
Hope helps.
Best regards,
Sean