Re: lengthy operation

Mike wrote:
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 ....

I can't say. Did you read my entire reply?


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

Not really. Executing a sql insert statement is done pretty much the same
way with both technologies. Basically, create a string containing an insert
statement that does what you want, something like:

"insert into table (column list) values (value list)"

and use the connection's Execute method to execute it

You will probably want to parameterize it and use parameters to pass the
values into the statement. I'm not really familiar with c++ so if you get no
further replies here, you should probably take this to a c++ group.

Retrieving data is quite different: datasets instead of recordsets, etc.

If you MUST use a recordset to do this, then do not use adCmdTable: use
adCmdText instead and put a WHERE clause on the sql statement:


"select <columns> from table where 0=1"

This where clause will cause the query to return an empty resultset. You can
then add a new record to the recordset.


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"

--
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: How does ADO 2 update a SQL stored procedure recordset?
    ... > Generally when I want to use ADO 2 to update a recordset based on a MSSQL ... > call a second stored procedure to perform the update. ... Well if you have SELECTed the columns in the recordset that form the Primary ... You are running SQL Server. ...
    (microsoft.public.data.ado)
  • 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)