01.<asp:SqlDataSource
02. ID="DS_Sale_Item"
03. runat="server"
04. ConnectionString="<%$ ConnectionStrings:ConSOH_SAP %>"
05. SelectCommand="SELECT ROW_NUMBER() OVER(ORDER BY SerialCode) AS No, dbo.t_GiDetail.PalletCode
06. FROM dbo.t_GiDetail WHERE (PalletCode = @palletcode) ORDER BY SerialCode">
07. <SelectParameters>
08. <asp:Parameter Name="PalletCode" />
09. </SelectParameters>
10. </asp:SqlDataSource>
11. <% if (PalletCode = "@PalletCode") %>
12. <asp:SqlDataSource
13. ID="DS_Sale_Item"
14. runat="server"
15. ConnectionString="<%$ ConnectionStrings:ConSOH_SAP %>"
16. SelectCommand="SELECT ROW_NUMBER() OVER(ORDER BY SerialCode) AS No,KKC_Loading.dbo.tran_Job.DeliveryDate
17. FROM KKC_Loading.dbo.tran_JobDo
18. WHERE (PalletCode = @palletcode) ORDER BY SerialCode"
19. <SelectParameters>
20. <asp:Parameter Name="PalletCode" />
21. </SelectParameters>
22. </asp:SqlDataSource>
23.
24. <% } %>
25.
