Transferring rows from one GridDataBoundGrid to another

Hi, I have two GridDataBoundGrids on a single form, which are populated by two different Dataset tables (which are populated by different SQL select queries). The columns and the data format in both the grids are same. I need to transfer rows from one grid to another upon click of a button. For example, if I select a row in the left side grid and click on "Add", it should remove that row from the left grid and add it to the right one. Similarly selecting a row in the right grid and clicking on "Remove", should remove the row from the right grid and add it to the left one. Can someone please help me with this? Thanks in advance, Raj

You couldn't just move copy and delete the datarow from the first grid data source and add the copy to the second grid data source. Let me know if this works for you Grer > Hi, > I have two GridDataBoundGrids on a single form, which are populated by two different Dataset tables (which are populated by different SQL select queries). The columns and the data format in both the grids are same. I need to transfer rows from one grid to another upon click of a button. > For example, if I select a row in the left side grid and click on "Add", it should remove that row from the left grid and add it to the right one. Similarly selecting a row in the right grid and clicking on "Remove", should remove the row from the right grid and add it to the left one. > > Can someone please help me with this? > Thanks in advance, > Raj >

Hi Grer, Yes, thanks, that did the trick. I manipulated the dataset directly and it worked. Thanks, Raj > You couldn't just move copy and delete the datarow from the first grid data source and add the copy to the second grid data source. > > Let me know if this works for you > Grer > > > Hi, > > I have two GridDataBoundGrids on a single form, which are populated by two different Dataset tables (which are populated by different SQL select queries). The columns and the data format in both the grids are same. I need to transfer rows from one grid to another upon click of a button. > > For example, if I select a row in the left side grid and click on "Add", it should remove that row from the left grid and add it to the right one. Similarly selecting a row in the right grid and clicking on "Remove", should remove the row from the right grid and add it to the left one. > > > > Can someone please help me with this? > > Thanks in advance, > > Raj > > >