private void btnOK_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(cbmname.Text)) { TfSQL con = new TfSQL(); string sqlpass = "******" + cbmname.Text + "' and user_pass = '******' "; { DataTable dt = new DataTable(); dt = con.sqlExecuteReader(sqlpass); //if (con.sqlExecuteScalarString(sqlpass) == cbmname.Text) if (dt.Rows.Count > 0 && dt.Rows[0]["user_name"].ToString() == cbmname.Text && dt.Rows[0]["user_pass"].ToString() == txtpass.Text) { UserData.usercode = dt.Rows[0]["user_name"].ToString(); UserData.username = dt.Rows[0]["full_name"].ToString(); UserData.isadmin = bool.Parse(dt.Rows[0]["admin_flag"].ToString()); MainFrm dg = new MainFrm(); this.Hide(); dg.ShowDialog(); this.Close(); } else { MessageBox.Show("Pass is not correct", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show("User name is null.", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Login_Load(object sender, EventArgs e) { if (System.Deployment.Application.ApplicationDeployment.IsNetworkDeployed) { Version deploy = System.Deployment.Application.ApplicationDeployment.CurrentDeployment.CurrentVersion; StringBuilder version = new StringBuilder(); version.Append("VERSION: "); version.Append(deploy.Major); version.Append("_"); version.Append(deploy.Build); version.Append("_"); version.Append(deploy.Revision); lbVersion.Text = version.ToString(); } cbmname.Focus(); TfSQL con = new TfSQL(); string sql = "select distinct user_name from iqc_user order by user_name"; con.getComboBoxData(sql, ref cbmname); AcceptButton = btnOK; }