How to check duplicate value in dataset using jquery

Question

0.00/5 (No votes)

See more:

, +

I have a dataset in with three columns

code desc price
black abc 20.00
white cbd 25.50
blue mnb 30.00

I want check duplicate record of textbox on button click of aspx form in dataset using jquery and display an alert if duplicate value exist in dataset.

how can i achieve this task

please help me

thanks in advance

Posted 3-Feb-14 23:39pm

Ravi Sargam

Add a Solution

Comments

Kornfeld Eliyahu Peter 4-Feb-14 5:43am

You question makes no sense! You mixing server and client side with no mercy...
Please review the question and clarify it...

Ravi Sargam 4-Feb-14 5:53am

Can i use Dataset in Jquery or not?

Kornfeld Eliyahu Peter 4-Feb-14 5:56am

DataSet as System.Data.DataSet? NO!!!
jQuery belongs to client side - DataSet is to the server side...
It seems to me that you confused about how a web site build up - please search for some basic books!

thatraja 4-Feb-14 8:10am

Always answer all our questions to give you perfect/recommended answers

2 solutions

Solution 2

Agree with Kornfeld. Do it either on server side or client side. Don't mix things. I give you samples, customize it.
Server side - Checking Existing Records Using Array of Data Rows[^]
Client side - JQUERY: Mark rows with identical values in a table[^]
Searching table rows with jQuery[^]

Posted 4-Feb-14 2:05am

thatraja

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)

CoderPanda · Accepted Answer · 2014-02-03T23:55:00

Solution 1

I am assuming
Duplicate means the entire row matches with an entire row, not only cells
You want to show the message after all the rows are filled, not after each row

I would suggest the following in javascript
1. For each row concatenate values of the 3 cells into one string
2. Get all these strings into one string array
3. Use code like this[^] to find out the duplicate entries and highlight those rows on your screen. You can also find many other such code snipets in JS to find out duplicate entries.

[Please encourage participation by accepting/up-voting answers or solutions that work for you]

Posted 3-Feb-14 23:55pm

CoderPanda

Comments

Ravi Sargam 4-Feb-14 6:11am

thanks..

CoderPanda 4-Feb-14 6:25am

Thanks for accepting it as a solution. But I am not sure if you or someone else downvoted it and why. I would like to know so that I can improve my answer.

Kornfeld Eliyahu Peter 4-Feb-14 6:27am

IMHO, as misleads as the question is. Where in you answer the DataSet comes in? Are you really think that this is a solution to check duplicate values in a data set (whatever type it has) - loop over table rows and cells to create hash of string!!! Move data related processes to data layer, keep UI in UI and know your framework!!!

CoderPanda 4-Feb-14 6:40am

Hello Kornfield, thanks for your valuable suggestions. I can think of the following without being sure about them:
1. The OP actually mentioned dataset but didn't really mean the c# ado.net dataset. He may just mean his data items as a whole.
2. The realtime need of a solution many a times outweigh the actual solution. So as long as the OP is benefited with it should we really complain. Of course I don't guarantee that my solution is 100% and I am just trying to help. And I think the OP's job is to ensure the solution actually fits into his overall design/architectre and the broad scheme of things.

Please let me know if you think this is a valid approach.

Kornfeld Eliyahu Peter 4-Feb-14 6:46am

IMHO giving a quick-and-dirty solution alone as a kind of crime!
If you not sure about the exact question - do not answer it! Ask for clarification.
If you after all answer it - do some good on the way and lit the light in the OP's brain...
You have the power!!!

CoderPanda 4-Feb-14 6:50am

Okay, thanks. I personally don't think this is a dirty solution. Agreed, may not be the best. I guess we would just agree to disagree in this case.

thatraja 4-Feb-14 8:09am

You got my vote.

thatraja 4-Feb-14 8:09am

IMO he mentioned only ADO.NET dataset. Sometime we should avoid posting answers without asking for more clarifications. I agree that still OP could use your answer & it's a working one, but not recommended.

So no vote for you. BTW Today I gave you 5 for an answer.

CoderPanda 4-Feb-14 8:40am

Thank you, it is always satisfying to be appreciated by people of your level of credibility.