2014年7月13日 星期日

[RESOLVED] open another page from gridview


Hello,  I have a gridview with an update statement, which can affect several records at a time..


the gridview has only 3 columns BagNo, Collectedby, Collected, when the update button is clicked it updates for example all bags with the number 5 that have not been collected yet. Each bag can contain several items.



UpdateCommand="UPDATE [Main] SET [Collected] = @Collected, [Collectedby] = @Collectedby,[DateCollected] = Getdate() WHERE [BagNo] = @BagNo and [Location] = @Loc and Collectedby is Null">

 


 Is it possible to have a button in the gridview for each record that when clicked will open another webpage with a list of the affected updated records which I can then print..i.e give me a list of all items in bag no 5?





Thanks very much..will try this


沒有留言:

張貼留言