how to create login with user roles using c# and sql server ?

This works for ASP.net. This is a series of article look into section suitable for you. If you requirement is Windows / WPF then create a WCF service to expose authentication features and call the service method from windows app.

http://www.asp.net/web-forms/tutorials/security/membership/creating-the-membership-schema-in-sql-server-cs[^]