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
