HOW TO PREVENT DUPLICATE RECORDS IN SQL EXPRESS 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mca - 26 May 2006 14:06 GMT

Hi everyone!

I am a computer engineer and have recently upgraded to .net 2005. With
new data components available, I have decided to write a simple
database application in order to get familiar with the new aspects of
.net 2005.

Here is my problem : When I try to update a record on an sql 2005
express database via a datalist component, updated records multiply
itself. Hence multiple instances of same record occupies my database.
Moreover these instances can not be deleted.

If anyone knows anything to fix this problem, please help me!

Sincerely;

Can AKPINAR
mehmetcanakpinar@gmail.com

Reply to this Message

Hilary Cotter - 28 May 2006 12:42 GMT

I think you need to only insert the rowschanged as opposed to each row in
the data list. Can we see your code to verfiy this is what is occurring?

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi everyone!
>
[quoted text clipped - 14 lines]
> Can AKPINAR
> mehmetcanakpinar@gmail.com

Reply to this Message