here is the code I write on the login form (which has two text boxes one for user name and the other for password and I have attached my MDI form.
thank you.
Expand|Select|Wrap|Line Numbers
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Text;
- using System.Windows.Forms;
- using Microsoft.VisualBasic;
- using System.Data.SqlClient;
- namespace Lesson01.Security
- {
- public partial class frmLogin : Form
- {
- Utilities.frmMDI frmMdi = new Lesson01.Utilities.frmMDI();
- public frmLogin()
- {
- InitializeComponent();
- }
- private void frmLogin_Load(object sender, EventArgs e)
- {
- }
- private void frmLoging_FormClosed(object sender, FormClosedEventArgs e)
- {
- Modules.modMain.frmLoging = null;
- }
- private void cmdOK_Click(object sender, EventArgs e)
- {
- string SQL = "";
- Class.clsConn dbConn = new Class.clsConn();
- SQL = "SELECT * FROM tblUser ";
- dbConn.Oreader(SQL);
- if (dbConn.reader != null)
- {
- if (dbConn.reader.Read())
- {
- if (txtUserName.Text.Trim() != dbConn.reader.GetString(0) && txtPassword.Text.Trim() == dbConn.reader.GetString(1))
- {
- MessageBox.Show("Please Enter Valid User Name");
- txtUserName.Text = "";
- txtUserName.Focus();
- frmMdi.mnuHelp.Visible = false;
- frmMdi.mnuOptions.Visible = false;
- frmMdi.mnuReport.Visible = false;
- frmMdi.mnuTask.Visible = false;
- }
- if (txtUserName.Text.Trim() == dbConn.reader.GetString(0) && txtPassword.Text.Trim() != dbConn.reader.GetString(1))
- {
- MessageBox.Show("Please Enter Valid password");
- txtPassword.Text = "";
- txtPassword.Focus();
- frmMdi.mnuHelp.Visible = false;
- frmMdi.mnuOptions.Visible = false;
- frmMdi.mnuReport.Visible = false;
- frmMdi.mnuTask.Visible = false;
- }
- if (txtUserName.Text.Trim() == dbConn.reader.GetString(0) && txtPassword.Text.Trim() == dbConn.reader.GetString(1))
- {
- Modules.modMain.userName = txtUserName.Text.Trim();
- frmMdi.mnuHelp.Visible = true;
- frmMdi.mnuOptions.Visible = true;
- frmMdi.mnuReport.Visible = true;
- frmMdi.mnuTask.Visible = true;
- dbConn.cn.Dispose();
- this.Close();
- }
- }
- }
- }
- private void cmdCancel_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- }
- }