Hi,
i have a form that has datagrid . in my datagrid i have a column that is a primary key in my sql table that called idnumber and when i enter data in datagrid after i press save button i want that code should check this out if any duplicate records existing on table in database and if exists give me message that is a duplicate record and clear the current row . how should i do that searched the solutions but couldn't find any useful one for me . Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
idnumber column is primary key in my table . for example 0301234 is my idnumber
0301234 | james brown is existing on my table
if i enter 0301234 again whatever the name is , code should check if any existing data with 0301234
if exists should give me message duplicate records . and so clear the last row which user tries (duplicate record) i hope that is clear.
don't let user change idnumber in your datagrid, auto generate it.
if u wanna make sure there are no duplciates in DB, before loading the datagrid, get the table from DB and store the idnumber fields.
that way u dont have to check for duplciation every time user click save.
when new row is added, auto generate idnumber and check it against the list of idnumbers u already got from DB and saved in some member in your form (List<int> for exmaple).
u can optimize it by sorting the list which contains the idnumbers and when generating new idnumber, u simply add 1 to the highest idnumber in the list.
hope it was clear enough
Business Accounts
Answer for Membership
by: sedgwickPosted on 2009-11-03 at 01:02:59ID: 25727108
duplicate records means the same name? same ID?
which field in your table/datagrid indicates duplication?