Checking a value in database

Question

Hi guys, I need help on checking the value in database, for example
if the user name already exist in the database, the user cant choose the same name.
can anyone help me on how to achieve that in C#
thanks.........