使用SqlDataSource仅在Listview中加载插入的项

本文关键字：插入 加载 SqlDataSource 仅在 Listview 使用 | 更新日期: 2023-09-27 17:53:00

我有一个SqlDataSource，它帮助Listview插入/删除新数据。但是，我不想使用这个SqlDataSource向Listview显示现有数据。只显示新插入的记录。但是，这显示了Listview上的所有内容。如果我删除SelectCommand，即使是新插入的行也不会显示。

  <asp:SqlDataSource ID="VendorSOAPaymentsInnerDS" runat="server"
      ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" 
      InsertCommand = "INSERT INTO VendorSOAPayments ( VendorSOAID, PaymentVoucherID, PaymentAmount) VALUES( @VendorSOAID, @PaymentVoucherID, @PaymentAmount)"  
      SelectCommand= "SELECT A.VendorSOAPaymentID, A.PaymentVoucherID, B.SubProjectID, B.StatementBreakDown, A.PaymentAmount, C.SubProjectCode, C.SubProjectName FROM  VendorSOAPayments A INNER JOIN VendorSOA B ON A.VendorSOAID = B.VendorSOAID INNER JOIN SubProject C ON B.SubProjectID = C.SubProjectID WHERE A.PaymentVoucherID  = @PaymentVoucherID  AND B.Vendor_EntityID = @VendorID "
     DeleteCommand = "DELETE VendorSOAPayments WHERE VendorSOAPaymentID = @VendorSOAPaymentID" >
     <SelectParameters>
          <asp:ControlParameter ControlID="ListPayVoucherID" Name="PaymentVoucherID" PropertyName="Value" />
          <asp:ControlParameter ControlID="vendorSelectID" Name="VendorID" PropertyName="Value" /> 
      </SelectParameters>
      <InsertParameters>
          <asp:Parameter Name="VendorSOAID" />
          <asp:Parameter Name="PaymentAmount" />
          <asp:ControlParameter ControlID="ListPayVoucherID" Name="PaymentVoucherID" PropertyName="Value" />
       </InsertParameters>
  </asp:SqlDataSource>

使用SqlDataSource仅在Listview中加载插入的项

可以将插入的记录添加到datatable中，并将datatable保存到会话中

相关文章：