How do i counter check data from the database using c#in Asp.net

Question

Hi Team,

how do i counter check the data which am entering through the textbox with the data in the current database.

for instance if i have store code "001" in the database, then i try entering the same code"001" using c# in asp.net it should give me an error like this "the code already exist"


regard

George