ado.net to create login form

Question

i will upload my project on next comment..

for tht i need to add login form with data acces layer

on my login form i have username,password and role

role have 2 values 1 . hr executive 2. other

executive have full privillage to my page

but in others will disable or invisible all butttons can any body can hel p me..plzzz

Vulpes · Answer

From the project menu add your Login form and populate it with textboxes for the username and password, a combobox for the role and buttons to log on or cancel. Then add code to the Login form as follows: public partial class Login : Form { internal static string UserName; // in case need this in other form internal static string Role; public Login() { InitializeComponent(); cmbRole.Items.Add("HR Executive"); cmbRole.Items.Add("Other Executive"); cmbRole.SelectedIndex = -1; this.DialogResult = DialogResult.None; } private void btnLogon_Click(object sender, EventArgs e) { if (txtUserName.Text.Trim().Length == 0) { MessageBox.Show("Please enter your user name"); txtUserName.Focus(); return; } if (txtPassword.Text.Trim().Length == 0) { MessageBox.Show("Please enter your user password"); txtPassword.Focus(); return; } if (cmbRole.SelectedIndex == -1) { MessageBox.Show("Please select your role"); cmbRole.Focus(); return; } bool isValid = ValidateUser(); if (isValid) { this.DialogResult = DialogResult.OK; UserName = txtUserName.Text; Role = cmbRole.SelectedItem.ToString(); this.Close(); } else { DialogResult dr = MessageBox.Show("Username, password or role are invalid", "What do you want to do?", MessageBoxButtons.RetryCancel); if (dr == DialogResult.Retry) { txtUserName.Text = ""; txtPassword.Text = ""; cmbRole.SelectedIndex = -1; txtUserName.Focus(); return; } else { this.DialogResult = DialogResult.Cancel; this.Close(); } } } private void btnCancel_Click(object sender, EventArgs e) { this.DialogResult = DialogResult.Cancel; this.Close(); } private bool ValidateUser() { // add code to validate password and role against username in database return true; // set to true or false for testing purposes } private void Login_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.None) // if it hasn't already been set { this.DialogResult = DialogResult.Cancel; } } } Finally add some code to the main form's constructor to open the login form and process the results: public partial class frmAddress : Form { int empId; public frmAddress() { InitializeComponent(); Login login = new Login(); DialogResult dr = login.ShowDialog(); if (dr == DialogResult.Cancel) { Environment.Exit(1); // kill process } if (Login.Role == "Other Executive") // make all buttons invisible { foreach (Control c in this.Controls) { if (c is Button) c.Visible = false; } } } // rest of code }

Sinu Joseph · Answer

plz find the attachments...

ado.net to create login form

Answers (2)