can you pls help me for code to check the duplicate data before instert or update records....
i work with Ms Access database 2003 with disconnection mode (dataset) into vb.net 2008
Jump to Post
I can't give you a specific query without knowing the structure of your table but in general if you do something like
SELECT COUNT(*) FROM mytable WHERE pkfieldname = value
where pkfieldname is the name of your primary key field and value is the value of …
All 4 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.