Just an update, I decided to go with Stephen's suggestion since the Access database will eventually go away. Also I had to do extensive data "massaging" before the data could be moved to the SQL db. With the class I could do just that.
Thanks to both of you for your suggestions! Jana On Jul 19, 11:35 pm, Cesar Perez Ramirez <cesar...@gmail.com> wrote: > I suggest to create a linked server with access , then just create an Stored > procedure with cre select insert stateman statements , then just call the SP > ..... its so easy . > > check this link about creating Linked Servers with access > > http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Micr... > > may the source be with you! > > > > On Tue, Jul 19, 2011 at 8:50 PM, DotNet Newbie <bauer.j...@gmail.com> wrote: > > Thanks, I'll give that a shot! > > > On Jul 19, 4:49 am, Stephen Russell <srussell...@gmail.com> wrote: > > > On Mon, Jul 18, 2011 at 10:57 PM, DotNet Newbie <bauer.j...@gmail.com> > > wrote: > > > > I apologize, I realize in re-reading my post that I wasn't quite > > > > clear. That label was just to confirm that I was successfully able to > > > > traverse the gridview and determine which records the user had > > > > chosen. Parsing the string is not where I'm stuck. My issue is > > > > this: I am not sure what object to use to port the selected records > > > > from the Access datasource of the gridview over to the SQL database > > > > destination table. The table structures are similar but not exactly > > > > the same. I am much more familiar with VBA and DAO, so maybe if I > > > > explain how I'd do it there, then you can tell me of an equivalent > > > > process I could do in ADO.Net. In DAO, I would do this series of > > > > steps: > > > > > 1. Create a connection to the Access db (source) > > > > 2. Create a connection to the SQL db (destination) > > > > 3. Run a SELECT statement on the source table to obtain only the > > > > selected records and store the results in a recordset > > > > 4. Traverse through the results recordset and append the new records > > > > to the destination table. > > > > > I have done some reading on DataSet and DataTable objects, but the > > > > reading has left me confused on when and how to use them, and whether > > > > that's what I need to use for this situation. > > > > > Hope that helps you help me :) > > > > ------------ > > > > Make a data object : > > > public class Users > > > { > > > > public int UserId > > > { > > > get; set; > > > } > > > > public string LoginName > > > { > > > get; set; > > > } > > > > public string FirstName > > > { > > > get; set; > > > } > > > > // more as needed. > > > > } > > > > As you iterate through the checked row put the value(s) into this > > > class that should mimic your SQL target in schema. > > > > Then you create a connection, populate the SPROC's parameters or you > > > generate the insert script dynamically. Execute the SQL command. > > > > -- > > > Stephen Russell > > > > Unified Health Services > > > 60 Germantown Court > > > Suite 220 > > > Cordova, TN 38018 > > > > Telephone: 888.510.2667 > > > > 901.246-0159 cell > > > -- > > You received this message because you are subscribed to the Google > > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > > Web Services,.NET Remoting" group. > > To post to this group, send email to dotnetdevelopment@googlegroups.com > > To unsubscribe from this group, send email to > > dotnetdevelopment+unsubscr...@googlegroups.com > > For more options, visit this group at > >http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > > or visit the group website athttp://megasolutions.net -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to dotnetdevelopment@googlegroups.com To unsubscribe from this group, send email to dotnetdevelopment+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
