How do I check duplicate field in the DataGridView

  • Thread starter Thread starter Tony Johansson
  • Start date Start date
T

Tony Johansson

Hello!

I have a DataGridView with 6 columns one of these is a social security
number that is unique to every person and
the primary key for the database table.

Now when I enter this social security number I want to check that it doesn't
exist in DataGridView because I want to avoid getting error from the
database when I save to the database.

What is the best way to do that ?

//Tony
 
Hello!

I have a DataGridView with 6 columns one of these is a  social security
number that is unique to every person and
the primary key for the database table.

Now when I enter this social security number I want to check that it doesn't
exist in DataGridView because I want to avoid getting error from the
database when I save to the database.

What is the best way to do that ?

//Tony
Click to expand...
you can add a css class to social security number textbox,for
example:
<EditItemTemplate>
<asp:TextBox runat="server"
CssClass="socialsecuritynumber"></asp:TextBox>
</EditItemTemplate>

then add a javascript keyup event handler to every html input whose
css name is "socialsecuritynumber", like this:
$(".socialsecuritynumber").keyup(function(){
//check security number doesn't exist
}
};

sorry for my poor english

---Osamede Zhang
 
Back
Top