VB.NET 2005 in Visual Studio 2005
I have a Windows form with two TDB grids (TDB1, TDB2).
TDB1 is bound to a .NET Dataset. When a user clicks an Add button, I want to add the TDB1 selected data rows to TDB2.
When the user dismisses the form, the rows in TDB2 will be added to an Excel spreadsheet.
What is the best-pratice for doing this? I've read about DataViews. Can I filter the underlying dataset bound to TDB1 and use that to bind to TDB2? Or is it simple to just add the rows to TDB2 w/out data binding? I do not need to update a database, just add TDB2 rows to Excel.
Thanks!