duplicate name not allow

You can check usingstring sql = string.format(" select count(*) from table name where name='{0}'", txtname.text);if it exitst it gives 1 else 0then u can allow to enter.