Check if value already exists in gridview.

[Crowley16]

A newbie to asp.net so go easy please...

Basically, I've got a gridview with update and insert. What I want to do is, when column1 is changed, before the save happens, check if the new value already exists somewhere else in column1 and if so, prompt the user to either overwrite or discard the new entry.

Not even sure how to start with this so any help appreciated.

--------------------
Procrastinate Now!

 

[jbenson001]

I would check if that value exists in the DB, not in the grid itself.

 

[Crowley16]

That would be ok as well.

but how do I do this check and feed back to the user before the event has happened?

--------------------
Procrastinate Now!

 

[th3maw]

There are two ways to do it. Either use Javascript to loop through the existing values and compare (throwing up an error/alert when required), or alternatively you could check the database using AJAX.

 

[jbenson001]

In what ever you save event is, pass the value the user entered into a sp and that sp will check if the value exits. Return a value to the front end with an output parameter and then do what you have to do based on that value.