Updating Access Database

[Guest]

I'm trying to update my access database through an oledb data adapter that
calls an access update stored procedure on my dataset. I realized that only
the first row modified gets updated in the database. All other rows remain
unchanged. Does anyone know why this is so and how I can fix it to update
all changed records?

Parvee

 

[Cor]

Hi Parveen,

I see this often in this newsgroup, what is the magic of a stored procedure,
it gives as much information as. "I do an update using a programma."

The question what is in the stored procedure and which commands you execute
to use that.
(For what the dataadapter is also a command for me)

I do not think that with this information somebody can really help you.

Just my thought,

Cor

 

[Ayaz Ahmed]

Hello,

All record update on their primary field bases and also you mention
where clause in your update query and also passing values in update
clause, after this one by one all fields update in your where clause
matching criteria .

i thinks its help you

Thanks,

Warm Regards,

Ayaz Ahmed
Software Engineer & Web Developer
Creative Chaos (Pvt.) Ltd.
"Managing Your Digital Risk"
http://www.csquareonline.com
Karachi, Pakistan
Mobile +92 300 2280950
Office +92 21 455 2414