Re: lengthy operation

I am not using .NET framework. I am using visual studio .NET 2003 because it
is better then the visual studio 6.
I do not want to use the ADO .NET because I don't want to use the .NET
framework. Maybe it is a bad choice ....

is there a big difference between ado and ado .NET to do what I want ?

thanks
Mike

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:O0PJHAMDHHA.4992@xxxxxxxxxxxxxxxxxxxxxxx
Mike wrote:
Hi !

I am a beginner in ado programming and I have some problems with
operations on huge tables. I am developping with visual studio .NET
2003.

Why are you using classic ADO in .Net? Since you have VS 2003, go look in
the online help for tutorials about working with data.



Which command can I use to insert a record in table ? my problem is
when I open the recordset associated with the table (thousands of
records), it takes very long time. But I don't want to get all
records, I only want to add a new one.

Use a SQL INSERT statement executed by a Command object. Don't use a
recordset


I used the following code to open the recordset :
pRecordSet->Open("table", pConnection, true, adOpenKeyset,
adLockOptimistic, acCmdTable);


I have never used adCmdTable to open a recordset. I ALWAYS create a sql
select statement with a WHERE clause to limit the data retrieved from the
database.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages

  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: DAO to ADO Recordset Options
    ... DAO was really fast when dealing with Access data (faster than ADO) but was ... Recordset. ... For client-sided cursors, there is only Static cursor type regardless as ... determines how often data is fetched from the server. ...
    (microsoft.public.data.ado)