ADODB recordset for migrate data



  • 1. Refresh Cache
    Hi! I must be the last one on the planet to know. I use a JET database for a webpage. When I delete rows it doesn't reflect on the page. I assume it has to do with the caching of the JET object. Does anyone know how to refresh this stuff. I do not want to use JRO for as far as I can understand it requires a ADO conncetion (as opposed to a ADO.NET connection). Isn't it weird how hard it is to find onfo about this as it must be a major issue for all developers? Grateful for tips! !Robert PS I am using code like: System.Data.OleDb.OleDbConnection cn; cn = new System.Data.OleDb.OleDbConnection(); cn.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString ").ToString(); cn.Open(); System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(); cmd.Connection = cn;
  • 2. Create Dataset
    After adding a DataAdapter and then trying to use the Generate DataSet wizard, I'm getting a message that Visual Studio can't generate an instance of the DataSet with advice to be sure that class is a valid DataSet class. It is a valid class as best I can determine. I can generate an instance if I manually enter code; whay can't Visual Studio? -- Al S
  • 3. Hi Wlliam
    I Would Like Know, If You Can Send Me A Message Mi Mail, where You Can Give A Recomendation.... Mi Mail is: XXXX@XXXXX.COM I Will be, Very Very Gratefull.... Thank You....

ADODB recordset for migrate data

Postby Alex » Mon, 30 Jun 2003 23:52:51 GMT

I have two separate databases and I would like to move a 
table from one database to another database. Is it 
possible to create a disconnected recordset in source 
table and then attached this recordset to destination 
Please advise. If not, any better generic approach?

Re: ADODB recordset for migrate data

Postby Val Mazur » Tue, 01 Jul 2003 22:16:20 GMT

Hi Alex,

In case if one database is SQL Server you have good tool, which calls SQL
DTS. It is fast way to transfer data between datasources.
Yes, you also could create disconnected recordset and re-attach it to
another DB, but it would require using of XML, since you need to modify
recordset to *mark* records as inserted to be able to transfer them to
another database. That way could be slow in case if database is very big. I
have an example how to do that. If you need it, let me know by e-mail and I
will send it to you. It is too big to post it here

Return to ADO


Who is online

Users browsing this forum: No registered users and 8 guest