Fastest way to set a field value in a given table

  • Thread starter Thread starter Ralph Wiggum
  • Start date Start date
R

Ralph Wiggum

I have some vb6 ado code that needs to be upgraded to .Net:

Set rs = CreateObject("ADODB.Recordset")
rs.Open "SELECT fieldname FROM tablename WHERE id=" & anyId, oConnection
rs(fieldname).value = anyValue
rs.close

The operation will be repeated many times, so performance is crucial. I've heard that DataTables are slow - what would be the best .Net approach here? OleDbCommand.ExecuteNonQuery(sql_update_statement)?

It's an Access database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import table access to excel 1
Passing a Recordset from VB6 to VB.Net (QueryInterface failed.) 12
How do I do this VB6 ADO code in ADO .NET 1
'Repeating' a Stored procedure 2
Excel How to connect to database through Macro Excel in MAC 0
No value given for one or more required parameters 3
Repost - Best way to get data from Access 2003 to Excel 2003 2
No value given for one or more required parameters 2

Back
Top