private void button1_Click(object sender, EventArgs e) { try { if (txtpwd.Text.Trim()==""||comboBox1.Text=="") { MessageBox.Show("�û��������벻��Ϊ�գ�", "��ʾ",//������Ϣ�Ի��� MessageBoxButtons.OK, MessageBoxIcon.Information); return;//�˳��¼� } else { string name = comboBox1.Text;//��ȡ�û��� string pwd = txtpwd.Text.Trim();//��ȡ���� SqlConnection conn = DBConnection.MyConnection();//�������ݿ����Ӷ��� conn.Open();//�����ݿ����� SqlCommand cmd = new SqlCommand(//�������ݿ�������� "select * from HPES_user where name='" + name + "' and password='******'", conn); SqlDataReader sdr = cmd.ExecuteReader();//�������ݶ�ȡ�� sdr.Read();//��ȡ���� if (sdr.HasRows)//�ж��Ƿ������� { string time = DateTime.Now.ToString();//�õ�ʱ����Ϣ string sql = //����SQL�ַ��� "update HPES_user set logintime='" + time + "' where name='" + name + "'"; operate.OperateData(sql);//�������ݿ���Ϣ this.MdiParent.Close();//�رո����� conn.Close();//�ر����� frmMain Main = new frmMain();//������������� //Main.loginuser.Text = name;//Ϊ�ֶθ�ֵ //Main.Logintime.Text = time;//Ϊ�ֶθ�ֵ Main.Show();//��ʾ������ } else { txtpwd.Text = "";//����ı����� comboBox1.Text = "";//����ı����� MessageBox.Show("�û������������", "��ʾ",//������Ϣ�Ի��� MessageBoxButtons.OK, MessageBoxIcon.Information); } } } catch (Exception ex)//�����쳣 { MessageBox.Show(ex.Message);//������Ϣ�Ի��� } }
private void uiButton1_Click(object sender, EventArgs e) { if (nameTxt.Text == "" || pwdTxt.Text == "")//判断用户名和密码是否为空 { MessageBox.Show("用户名或密码不能为空!",//弹出消息对话框 "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return;//退出事件 } else { string name = nameTxt.Text.Trim();//移除用户名前部和后部的空格 string pwd = pwdTxt.Text.Trim();//移除密码前部和后部的空格 SqlConnection conn = DBClass.DBConnection.MyConnection();//创建数据库连接对象 conn.Open();//连接到SQL数据库 //SqlCommand cmd = new SqlCommand(//创建数据库命令对象 // "select * from HPES_user where name='" + // name + "' and password='******'", conn); SqlCommand cmd = new SqlCommand("select * from HPES_user where name='" + name + "' and password='******'", conn); SqlDataReader sdr = cmd.ExecuteReader();//得到数据读取器对象 sdr.Read();//读取一条记录 if (sdr.HasRows)//判断是否包含数据 { string time = DateTime.Now.ToString();//得到系统时间字符串 string sql = "update HPES_user set logintime='" //设置更新数据库的SQL语句 + time + "' where name='" + name + "'"; operate.OperateData(sql);//更新数据库内容 conn.Close();//关闭数据库连接 //this.Hide();//隐藏窗体 //FrmMain main = new FrmMain();//创建主窗体对象 ////main.loginuser.Text = name;//为主窗体字段赋值 ////main.Logintime.Text = time;//为主窗体字段赋值 //main.Show();//显示主窗体 frmMain frmMain = new frmMain(); frmMain.Show(); this.Hide(); } else { nameTxt.Text = "";//清空用户名 pwdTxt.Text = "";//清空密码 MessageBox.Show("用户名或密码错误!", "提示",//弹出消息对话框 MessageBoxButtons.OK, MessageBoxIcon.Information); } } }