I want to hide Employee Attendance form on mdi parent form when a teacher will login from login form and when admin login all forms will show

Question

0.00/5 (No votes)

See more:

I want to hide Employee Attendance form on mdi parent form when a teacher wil login from login form and when admin login all forms will show.

Posted 2-Oct-15 20:37pm

Anil Raina

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 3-Oct-15 2:51am

Where is the issue?

Anil Raina 6-Oct-15 2:26am

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace SMS._forms
{
public partial class frm_login : Form
{
public frm_login()
{
InitializeComponent();
}
_class.clsODBC cls_ODBC = new SMS._class.clsODBC();
_forms.MDIParent mdi_Parent = new MDIParent();

private void cancel_Click(object sender, EventArgs e)
{
Application.Exit();
}

private void frm_login_Load(object sender, EventArgs e)
{
this.com_uName.Focus();
index_Load();
setUserName();
}
#region <=== Index Region ====>
private void index_Load()
{
this.com_uName.TabIndex = 0;
this.txtPass.TabIndex = 1;
this.btn_Login.TabIndex = 2;
this.cancel.TabIndex = 3;

}
#endregion

#region <=== Add Users in ComboBox ===>
private void setUserName()
{

try
{
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();

}

cls_ODBC.cn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select u_id from user_", cls_ODBC.cn);
da.Fill(ds, "user_");
this.com_uName.DataSource = ds.Tables["user_"];
this.com_uName.DisplayMember = "u_id";
this.com_uName.ValueMember = "u_id";
cls_ODBC.cn.Close();
}

catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
#endregion

#region <=== Check Valid User ===>

private void btn_Login_Click(object sender, EventArgs e)
{

try
{
OleDbCommand cmdlogin = new OleDbCommand("select * from user_ where u_id='" + this.com_uName.SelectedValue + "' and pw='" + this.txtPass .Text.Trim() + "'", this.cls_ODBC .cn);
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();
}

cls_ODBC.cn.Open();
OleDbDataReader drpassword = cmdlogin.ExecuteReader();
if (drpassword.Read())
{
cls_ODBC.cn.Close();
drpassword.Close();
cmdlogin.Dispose();
this.Dispose(true);

MessageBox.Show("Welcome User", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
mdi_Parent.Show();

}
else
{

MessageBox.Show("Username or Password is not valid ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message );
}
}

#endregion

}
}
This is my login page code What will I write more such that a user can not get access to employee attendance form(frmEmpAtt) on mdi parent form.

OriginalGriff 3-Oct-15 3:33am

And?
What have you tried?
Where are you stuck?
What help do you need?

Anil Raina 6-Oct-15 2:26am

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace SMS._forms
{
public partial class frm_login : Form
{
public frm_login()
{
InitializeComponent();
}
_class.clsODBC cls_ODBC = new SMS._class.clsODBC();
_forms.MDIParent mdi_Parent = new MDIParent();

private void cancel_Click(object sender, EventArgs e)
{
Application.Exit();
}

private void frm_login_Load(object sender, EventArgs e)
{
this.com_uName.Focus();
index_Load();
setUserName();
}
#region <=== Index Region ====>
private void index_Load()
{
this.com_uName.TabIndex = 0;
this.txtPass.TabIndex = 1;
this.btn_Login.TabIndex = 2;
this.cancel.TabIndex = 3;

}
#endregion

#region <=== Add Users in ComboBox ===>
private void setUserName()
{

try
{
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();

}

cls_ODBC.cn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select u_id from user_", cls_ODBC.cn);
da.Fill(ds, "user_");
this.com_uName.DataSource = ds.Tables["user_"];
this.com_uName.DisplayMember = "u_id";
this.com_uName.ValueMember = "u_id";
cls_ODBC.cn.Close();
}

catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
#endregion

#region <=== Check Valid User ===>

private void btn_Login_Click(object sender, EventArgs e)
{

try
{
OleDbCommand cmdlogin = new OleDbCommand("select * from user_ where u_id='" + this.com_uName.SelectedValue + "' and pw='" + this.txtPass .Text.Trim() + "'", this.cls_ODBC .cn);
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();
}

cls_ODBC.cn.Open();
OleDbDataReader drpassword = cmdlogin.ExecuteReader();
if (drpassword.Read())
{
cls_ODBC.cn.Close();
drpassword.Close();
cmdlogin.Dispose();
this.Dispose(true);

MessageBox.Show("Welcome User", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
mdi_Parent.Show();

}
else
{

MessageBox.Show("Username or Password is not valid ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message );
}
}

#endregion

}
}
This is my login page code What will I write more such that a user can not get access to employee attendance form(frmEmpAtt) on mdi parent form.

BillWoodruff 3-Oct-15 4:40am

Show the code you are using now, and tell us what doesn't work.

Anil Raina 6-Oct-15 2:25am

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace SMS._forms
{
public partial class frm_login : Form
{
public frm_login()
{
InitializeComponent();
}
_class.clsODBC cls_ODBC = new SMS._class.clsODBC();
_forms.MDIParent mdi_Parent = new MDIParent();

private void cancel_Click(object sender, EventArgs e)
{
Application.Exit();
}

private void frm_login_Load(object sender, EventArgs e)
{
this.com_uName.Focus();
index_Load();
setUserName();
}
#region <=== Index Region ====>
private void index_Load()
{
this.com_uName.TabIndex = 0;
this.txtPass.TabIndex = 1;
this.btn_Login.TabIndex = 2;
this.cancel.TabIndex = 3;

}
#endregion

#region <=== Add Users in ComboBox ===>
private void setUserName()
{

try
{
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();

}

cls_ODBC.cn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select u_id from user_", cls_ODBC.cn);
da.Fill(ds, "user_");
this.com_uName.DataSource = ds.Tables["user_"];
this.com_uName.DisplayMember = "u_id";
this.com_uName.ValueMember = "u_id";
cls_ODBC.cn.Close();
}

catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
#endregion

#region <=== Check Valid User ===>

private void btn_Login_Click(object sender, EventArgs e)
{

try
{
OleDbCommand cmdlogin = new OleDbCommand("select * from user_ where u_id='" + this.com_uName.SelectedValue + "' and pw='" + this.txtPass .Text.Trim() + "'", this.cls_ODBC .cn);
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();
}

cls_ODBC.cn.Open();
OleDbDataReader drpassword = cmdlogin.ExecuteReader();
if (drpassword.Read())
{
cls_ODBC.cn.Close();
drpassword.Close();
cmdlogin.Dispose();
this.Dispose(true);

MessageBox.Show("Welcome User", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
mdi_Parent.Show();

}
else
{

MessageBox.Show("Username or Password is not valid ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message );
}
}

#endregion

}
}
This is my login page code What will I write more such that a user can not get access to employee attendance form(frmEmpAtt) on mdi parent form.

VR Karthikeyan 4-Oct-15 9:13am

Use role based flags to show / hide forms. Just define a role (ex. Teacher) and store form details that you want to show for the teacher login. From the stored form details you can show / hide your forms.

Anil Raina 6-Oct-15 2:25am

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace SMS._forms
{
public partial class frm_login : Form
{
public frm_login()
{
InitializeComponent();
}
_class.clsODBC cls_ODBC = new SMS._class.clsODBC();
_forms.MDIParent mdi_Parent = new MDIParent();

private void cancel_Click(object sender, EventArgs e)
{
Application.Exit();
}

private void frm_login_Load(object sender, EventArgs e)
{
this.com_uName.Focus();
index_Load();
setUserName();
}
#region <=== Index Region ====>
private void index_Load()
{
this.com_uName.TabIndex = 0;
this.txtPass.TabIndex = 1;
this.btn_Login.TabIndex = 2;
this.cancel.TabIndex = 3;

}
#endregion

#region <=== Add Users in ComboBox ===>
private void setUserName()
{

try
{
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();

}

cls_ODBC.cn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select u_id from user_", cls_ODBC.cn);
da.Fill(ds, "user_");
this.com_uName.DataSource = ds.Tables["user_"];
this.com_uName.DisplayMember = "u_id";
this.com_uName.ValueMember = "u_id";
cls_ODBC.cn.Close();
}

catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
#endregion

#region <=== Check Valid User ===>

private void btn_Login_Click(object sender, EventArgs e)
{

try
{
OleDbCommand cmdlogin = new OleDbCommand("select * from user_ where u_id='" + this.com_uName.SelectedValue + "' and pw='" + this.txtPass .Text.Trim() + "'", this.cls_ODBC .cn);
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();
}

cls_ODBC.cn.Open();
OleDbDataReader drpassword = cmdlogin.ExecuteReader();
if (drpassword.Read())
{
cls_ODBC.cn.Close();
drpassword.Close();
cmdlogin.Dispose();
this.Dispose(true);

MessageBox.Show("Welcome User", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
mdi_Parent.Show();

}
else
{

MessageBox.Show("Username or Password is not valid ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message );
}
}

#endregion

}
}
This is my login page code What will I write more such that a user can not get access to employee attendance form(frmEmpAtt) on mdi parent form.

Anil Raina 6-Oct-15 2:25am

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace SMS._forms
{
public partial class frm_login : Form
{
public frm_login()
{
InitializeComponent();
}
_class.clsODBC cls_ODBC = new SMS._class.clsODBC();
_forms.MDIParent mdi_Parent = new MDIParent();

private void cancel_Click(object sender, EventArgs e)
{
Application.Exit();
}

private void frm_login_Load(object sender, EventArgs e)
{
this.com_uName.Focus();
index_Load();
setUserName();
}
#region <=== Index Region ====>
private void index_Load()
{
this.com_uName.TabIndex = 0;
this.txtPass.TabIndex = 1;
this.btn_Login.TabIndex = 2;
this.cancel.TabIndex = 3;

}
#endregion

#region <=== Add Users in ComboBox ===>
private void setUserName()
{

try
{
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();

}

cls_ODBC.cn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter("select u_id from user_", cls_ODBC.cn);
da.Fill(ds, "user_");
this.com_uName.DataSource = ds.Tables["user_"];
this.com_uName.DisplayMember = "u_id";
this.com_uName.ValueMember = "u_id";
cls_ODBC.cn.Close();
}

catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
#endregion

#region <=== Check Valid User ===>

private void btn_Login_Click(object sender, EventArgs e)
{

try
{
OleDbCommand cmdlogin = new OleDbCommand("select * from user_ where u_id='" + this.com_uName.SelectedValue + "' and pw='" + this.txtPass .Text.Trim() + "'", this.cls_ODBC .cn);
if (cls_ODBC.cn.State == ConnectionState.Open)
{
cls_ODBC.cn.Close();
}

cls_ODBC.cn.Open();
OleDbDataReader drpassword = cmdlogin.ExecuteReader();
if (drpassword.Read())
{
cls_ODBC.cn.Close();
drpassword.Close();
cmdlogin.Dispose();
this.Dispose(true);

MessageBox.Show("Welcome User", "School Management System", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
mdi_Parent.Show();

}
else
{

MessageBox.Show("Username or Password is not valid ", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message );
}
}

#endregion

}
}
This is my login page code What will I write more such that a user can not get access to employee attendance form(frmEmpAtt) on mdi parent form.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)