C# duplicate entry before saving

Question

0.00/5 (No votes)

See more:

Hai,

I am about to developing a program which is stucked at starting only

Problem : When a user enter some text and click save that should be checked with database whether it is same or not and say Duplicate entry if same, else save to the database

ThnQ

Posted 18-Aug-12 2:27am

srinu2008

Add a Solution

Comments

[no name] 18-Aug-12 8:48am

"Problem : "... exactly how is that a "problem"? That is a requirement statement and not a problem or a question. You would benefit by reading http://www.codeproject.com/Articles/64628/Code-Project-Quick-Answers-FAQ paying particular attention to item #4

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2012-08-19T00:04:00

Solution 3

In my opinion you should utilize the capabilities of the database to enforce the integrity of the data.

The easiest way is perhaps to define a unique constraint on the table. This constraint would ensure that no duplicate rows exist in the table. If a duplicate is trying to be added an exception is thrown which you can then catch in your application.

To learn more about unique constraint, see: http://msdn.microsoft.com/en-us/library/ms191166(v=sql.105).aspx[^]

Posted 19-Aug-12 0:04am

Wendelius

Comments

srinu2008 19-Aug-12 8:05am

Hai, Thnxs for the solution, actually i got a foxpro code about this, that i want to convert in C#
************************************************************************
procedure save_clas_det

if(empty(tcur_clas))

do mesg_wind with 'Incomplete Details . Please Check......'

return

endif

decl temp_arr[1]

if(told_or_new = 1)

sele 5
seek class_arr[tclass_no,2]

trec_no = recno()

temp_arr = 0

select count(*) from &tcl_det_file ;
where name = tcur_clas .and. recno() # trec_no ;
into array temp_arr

if(temp_arr[1] > 0)

do mesg_wind with 'Duplicate Entry . Please Check......'

return

endif

else

temp_arr = 0

select count(*) from &tcl_det_file ;
where name = tcur_clas ;
into array temp_arr

if(temp_arr[1] > 0)

do mesg_wind with 'Duplicate Entry . Please Check......'

return

endif

sele 5
append blank

temp_arr = 0

select max(class) from &tcl_det_file ;
into array temp_arr

repl class with temp_arr[1] + 1

endif

repl name with tcur_clas

if(told_or_new = 1)

if(tcur_clas # substr(class_arr[tclass_no,1],3))

class_arr[tclass_no,1] = space(2) + tcur_clas

show gets

endif

else

do get_cl_det with .f.

tcur_clas = space(tclas_name_len)

show gets

endif

do mesg_wind with 'Class Details Saved......'

******************************************************
It is the piece of code which i want to convert in C# plz let me know, ThnQ

Wendelius 19-Aug-12 8:26am

As said, I really don't recommend to do the check using the code. There are several possible problems you may encounter in a multi-user environment. In my opinion using a constraint would be the preferred way!

Espen Harlinn 19-Aug-12 8:37am

Good reply :-D

Wendelius 21-Aug-12 1:01am

Thanks :)

**AmitGajjar** · Answer 2 · 2012-08-18T02:57:00

Solution 1

Hi,

You can write your logic in Stored procedure.

Please check this article :Insert, Update, Search and Delete (CRUD operation) using ASP.Net and MySQL[^]

You have not tag which database you are using.Anyway Here is some code for stored procedure checking. i leave rest on you,

SQL

CREATE PROCEDURE `InsertCountry`(
IN     _CountryName                       varchar(200),
OUT    _ReturnValue                       int
)
BEGIN
 
DECLARE IsCountryExist int(5);
--check if country already exist in database. 
SELECT COUNT(NM_COUNTRY_ID) INTO IsCountryExist FROM
       TBL_COUNTRYMASTER WHERE VC_COUNTRY_NAME = _CountryName;
 
START TRANSACTION;
-- insert record only if duplicate country is not in database.
IF IsCountryExist = 0 THEN
   INSERT INTO TBL_COUNTRYMASTER(VC_COUNTRY_NAME)
          VALUES (_CountryName);
 
END IF;
 
SELECT LAST_INSERT_ID() INTO _ReturnValue;
 
COMMIT;
END

Hope you got answer from my solution.

Thanks
-Amit Gajjar

Posted 18-Aug-12 2:57am

AmitGajjar

Comments

srinu2008 19-Aug-12 8:05am

Hai, Thnxs for the solution, actually i got a foxpro code about this, that i want to convert in C#
************************************************************************
procedure save_clas_det

if(empty(tcur_clas))

do mesg_wind with 'Incomplete Details . Please Check......'

return

endif

decl temp_arr[1]

if(told_or_new = 1)

sele 5
seek class_arr[tclass_no,2]

trec_no = recno()

temp_arr = 0

select count(*) from &tcl_det_file ;
where name = tcur_clas .and. recno() # trec_no ;
into array temp_arr

if(temp_arr[1] > 0)

do mesg_wind with 'Duplicate Entry . Please Check......'

return

endif

else

temp_arr = 0

select count(*) from &tcl_det_file ;
where name = tcur_clas ;
into array temp_arr

if(temp_arr[1] > 0)

do mesg_wind with 'Duplicate Entry . Please Check......'

return

endif

sele 5
append blank

temp_arr = 0

select max(class) from &tcl_det_file ;
into array temp_arr

repl class with temp_arr[1] + 1

endif

repl name with tcur_clas

if(told_or_new = 1)

if(tcur_clas # substr(class_arr[tclass_no,1],3))

class_arr[tclass_no,1] = space(2) + tcur_clas

show gets

endif

else

do get_cl_det with .f.

tcur_clas = space(tclas_name_len)

show gets

endif

do mesg_wind with 'Class Details Saved......'

******************************************************
It is the piece of code which i want to convert in C# plz let me know, ThnQ

AmitGajjar 20-Aug-12 0:04am

but why can't you write your own code C#?

srinu2008 20-Aug-12 0:31am

I am beginner to C# and i don't know how to code in C#, thats why i am seeking help, plz let me know, ThnQ

AmitGajjar 20-Aug-12 0:33am

i know dear, thats why i have given you an article for beginner. you go though once and download demo and learn from there. i know it will be hard for you to start but once you will be families, you will love it.

srinu2008 20-Aug-12 0:36am

ok, i will go through, meanwhile if you have knowledge in that above code to convert into C#, please let me know, and can i have your mail id so that i keep on posting doubts so that i can get quick reply and also gains much experience too, Plz accept my request, ThnQ

AmitGajjar 20-Aug-12 0:40am

Posting question to one is not good idea, i suggest you to post question in Code project. So many people can help you.

srinu2008 20-Aug-12 0:41am

Oh okk, Can you convert that code into C# plz

srinu2008 20-Aug-12 0:45am

I am also bit confused while moving to non-GUI interface i.e.,dos based applications(Foxpro) to GUI based interface C#, I didn't understand what type of controls i had to use to get the output, Suggestions Plz

AmitGajjar 20-Aug-12 0:47am

download demo application from given article and check what kind of controls i have used.

srinu2008 20-Aug-12 0:49am

which demo application, i didn't find any thing in your profile too, plz post it again, ThnQ

AmitGajjar 20-Aug-12 0:54am

www.codeproject.com/Articles/438259/Insert-Update-Search-and-Delete-CRUD-operation-usi

Check this article.

Kuthuparakkal · Answer 3 · 2012-08-18T05:16:00

Solution 2

Lets try with EmployeeDetails, and you are trying to INSERT new/existing EmpID.

SQL

INSERT INTO dbo.EmployeeDetails(EmpID)
SELECT '123456'
WHERE NOT EXISTS (SELECT EmpID FROM dbo.EmployeeDetails WHERE EmpID = '123456')

Here 123456 will get into this table only if 123456 does not exist.

Thanks,

Kuthuparakkal

Posted 18-Aug-12 5:16am

Kuthuparakkal

Updated 18-Aug-12 18:40pm

v4

Comments

srinu2008 19-Aug-12 8:05am

Hai, Thnxs for the solution, actually i got a foxpro code about this, that i want to convert in C#
************************************************************************
procedure save_clas_det

if(empty(tcur_clas))

do mesg_wind with 'Incomplete Details . Please Check......'

return

endif

decl temp_arr[1]

if(told_or_new = 1)

sele 5
seek class_arr[tclass_no,2]

trec_no = recno()

temp_arr = 0

select count(*) from &tcl_det_file ;
where name = tcur_clas .and. recno() # trec_no ;
into array temp_arr

if(temp_arr[1] > 0)

do mesg_wind with 'Duplicate Entry . Please Check......'

return

endif

else

temp_arr = 0

select count(*) from &tcl_det_file ;
where name = tcur_clas ;
into array temp_arr

if(temp_arr[1] > 0)

do mesg_wind with 'Duplicate Entry . Please Check......'

return

endif

sele 5
append blank

temp_arr = 0

select max(class) from &tcl_det_file ;
into array temp_arr

repl class with temp_arr[1] + 1

endif

repl name with tcur_clas

if(told_or_new = 1)

if(tcur_clas # substr(class_arr[tclass_no,1],3))

class_arr[tclass_no,1] = space(2) + tcur_clas

show gets

endif

else

do get_cl_det with .f.

tcur_clas = space(tclas_name_len)

show gets

endif

do mesg_wind with 'Class Details Saved......'

******************************************************
It is the piece of code which i want to convert in C# plz let me know, ThnQ