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-Microsoft-Access-Server-on-SQL-2005-Server/ may the source be with you! On Tue, Jul 19, 2011 at 8:50 PM, DotNet Newbie <[email protected]> wrote: > Thanks, I'll give that a shot! > > On Jul 19, 4:49 am, Stephen Russell <[email protected]> wrote: > > On Mon, Jul 18, 2011 at 10:57 PM, DotNet Newbie <[email protected]> > 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 [email protected] > To unsubscribe from this group, send email to > [email protected] > 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 > -- 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 [email protected] To unsubscribe from this group, send email to [email protected] 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
