private void btnlogin_Click(object sender, EventArgs e) { #region Nhan bien nguoi dung nhap txtusername.Focus(); string username = txtusername.Text; string password = txtpassword.Text; #endregion #region Kiem tra gia tri nhap vao if (string.IsNullOrEmpty(username)) { MessageBox.Show("Nhập tên đăng nhập!", "Cảnh báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); txtusername.Focus(); return; } if (string.IsNullOrEmpty(password)) { MessageBox.Show("Nhập mật khẩu!", "Cảnh báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); txtpassword.Focus(); return; } #endregion #region Ket noi CSDL va truy van String sql = "select * from nhanvien a, quyennhanvien b where a.nv_id = b.nv_id and nv_tentaikhoan ='" + username + "' and nv_matkhau ='" + mahoa(password) + "'"; String sql2 = "select * from nhanvien where nv_tentaikhoan ='" + username + "' and nv_matkhau ='" + mahoa(password) + "'"; DataTable data = func.getdata(sql); DataTable data2 = func.getdata(sql2); if (data.Rows.Count > 0) { int tongquyen = data.Rows.Count; int[] quyen = new int[tongquyen]; int i = 0; foreach (DataRow row in data.Rows) { quyen[i] = Convert.ToInt32(row["q_id"]); i++; } foreach (DataRow row2 in data2.Rows) { index index_ = new index(); index_.getdata(row2["nv_id"].ToString(), row2["nv_hoten"].ToString(), quyen); index_.Show(); this.Hide(); } } else { MessageBox.Show("Đăng nhập thất bại!", "Error", MessageBoxButtons.OKCancel, MessageBoxIcon.Error); } #endregion }
private void load() { string sql = "select dt_ma, dt_ten,dt_mota, k_ten from daotao a, khoa b where a.k_id = b.k_id"; DataTable data = func.getdata(sql); dataGridView1.DataSource = data; string sql2 = "select * from khoa "; DataTable data2 = func.getdata(sql2); foreach (DataRow row in data2.Rows) { cbkhoa.Items.Add(row["k_ten"]); } }
private void load() { string sql = "select nv_hoten, nv_ngaysinh,case when nv_gioitinh =1 then 'Nam' else 'Nữ' end as nv_gioitinh, nv_diachi, nv_dienthoai, nv_email, k_ten from nhanvien a, khoa b where a.k_id = b.k_id"; DataTable data = func.getdata(sql); dataGridView1.DataSource = data; string sql2 = "select * from khoa "; DataTable data2 = func.getdata(sql2); foreach (DataRow row in data2.Rows) { txtkhoa.Items.Add(row["k_ten"]); } }
private void UserControl1_Load(object sender, EventArgs e) { String sql = "select nv_hoten, case WHEN nv_gioitinh =0 then 'Nam' ELSE 'Nữ' END as nv_gioitinh ,nv_dienthoai,nv_diachi, nv_email, q_ten from nhanvien a, quyennhanvien b, quyen c where a.nv_id = b.nv_id and b.q_id = c.q_id"; DataTable data = func.getdata(sql); this.dataGridView2.DataSource = data; }
private void load() { string sql = "select dk_id, sv_hoten, case when sv_gioitinh = 0 then 'Nam' else 'Nữ' end as sv_gioitinh, sv_dienthoai, dt_ten, dk_trangthai from sinhvien a , dangky b , daotao c where a.sv_id = b.sv_id and b.dt_id = c.dt_id"; DataTable data = func.getdata(sql); dataGridView1.DataSource = data; }
private void button1_Click(object sender, EventArgs e) { string sql = "select SUM(kq_tichluy) as tichluy, a.sv_hoten, case when a.sv_gioitinh =1 then 'Nam' else 'Nữ' end as sv_gioitinh,a.sv_ngaysinh, a.sv_diachi from sinhvien a, ketqua b where a.sv_id = b.sv_id GROUP by a.sv_hoten,a.sv_gioitinh,a.sv_ngaysinh, a.sv_diachi HAVING tichluy >2"; DataTable data = func.getdata(sql); reportViewer1.LocalReport.ReportEmbeddedResource = "WindowsFormsApplication1.bangtotnghiep.rdlc"; reportViewer1.LocalReport.DataSources.Add(new ReportDataSource("DataSet1", data)); reportViewer1.RefreshReport(); }
public void show_data() { string sql = "select * from nhanvien where nv_id =" + id; DataTable data = func.getdata(sql); foreach (DataRow row in data.Rows) { this.txthoten.Text = row["nv_hoten"].ToString(); this.txtsdt.Text = row["nv_dienthoai"].ToString(); this.txtgioitinh.Text = (Convert.ToInt32(row["nv_gioitinh"]) == 1) ? "Nam" : "Nữ"; this.txtdiachi.Text = row["nv_diachi"].ToString(); this.txtemail.Text = row["nv_email"].ToString(); this.txttaikhoan.Enabled = false; this.txttaikhoan.Text = row["nv_tentaikhoan"].ToString(); } }