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?
You can see related records
in modal popup:
http://www.dotnetcurry.com/ShowArticle.aspx?ID=212
in hierarchical/nested manner:
http://www.aspsnippets.com/Articles/Nested-GridView-Example-in-ASPNet-using-C-and-VBNet.aspx
Thanks very much..will try this
沒有留言:
張貼留言