restrict duplicate data insertion using textbox

Question

restrict duplicate data insertion using textbox in my table i already have a male if enter ma le it allows the data to insert into sql how to restrict these kind of records

Manoj Kumar Mandal · Answer

Try converting the text to lower case along with trim str = str.toLower().Trim(); Will convert your string to lower case and remove all the whitespaces between text.

muthukumar · Answer

trim only eliminate prefix empty space and behind empty space i need if i type Mal e like this or any word mispelled also check

Rajkiran Swain · Answer

Hello muthukumar U should use Trim Function to restrict Duplicate data or server side validation and client side validation ..

Siva Sankar · Answer

Hi Kumar Trim the text which was entered in textbox.... like... txtname . Text . Trim()