User Role Creation in c# windows forms

Question

Hi to all I want create User Roles to maintain Login User details in c# Windows Forms Application(Db:SqlServer)

Ravi Shekhar · Answer

This is a best method to use role by userid.

Sanjeeb Lenka · Answer

I think this one is the good method .

NAGARAJU TAMADA · Answer

Thanks for your Answer sir I had already done like thatis there any another method sir Thanks & Regards Nagaraju T

Pankaj Pandey · Answer

hii you can use this structure to manage role in login.. role table CREATE TABLE [dbo].[roles]( [roleId] [int] IDENTITY(11) NOT NULL [roleName] [nvarchar](30) NULL [internalFunctions] [varchar](128) NULL ) user table CREATE TABLE [users]( [userId] [int] IDENTITY(11) NOT NULL [eMail] [nvarchar](128) NULL [password] [nvarchar](30) NULL [firstName] [nvarchar](50) NULL [lastName] [nvarchar](50) NULL [companyName] [nvarchar](50) NULL [phoneNumber] [nvarchar](50) NULL [roleId] [int] NULL [disabled] [int] NULL [deleted] [int] NULL [createUserId] [int] NULL [createDate] [datetime] NULL [updateUserId] [int] NULL [updateDate] [datetime] NULL )

Sanjeeb Lenka · Answer

hi in your user table add one more column Role. At time of user registration insert the role into that. When login you can check it from database according to userid and role;