private void btnLuu_Click(object sender, EventArgs e) { DAO.OpenConnection(); string sql; if (cmbMaDoi.Text.Length == 0) { MessageBox.Show("Ban chua nhap ma doi"); cmbMaDoi.Focus(); return; } if (txtMaSan.Text == "") { MessageBox.Show("Ban chua nhap ma san"); txtMaSan.Focus(); return; } if (txtTenDoi.Text == "") { MessageBox.Show("Ban chua nhap ten doi"); txtTenDoi.Focus(); return; } if (txtHLV.Text == "") { MessageBox.Show("Ban chua nhap ten HLV"); txtHLV.Focus(); return; } if (txtMaTinh.Text == "") { MessageBox.Show("Ban chua nhap ma tinh"); txtMaTinh.Focus(); return; } /*if (txtLogo.Text.Trim().Length == 0) * { * MessageBox.Show("Ban chua nhap Logo"); * txtLogo.Focus(); * return; * }*/ /*if (txtLogo.Text == "") * { * MessageBox.Show("Bạn cần nhập logo!"); * txtLogo.Focus(); * return; * }*/ sql = "Select madoi from doibong where madoi = '" + cmbMaDoi.Text + " ' "; if (DAO.checkKeyExit(sql)) { MessageBox.Show("Ma doi da ton tai"); cmbMaDoi.Focus(); cmbMaDoi.Text = ""; return; } else { sql = "insert into doibong (madoi,tendoi,masan,HLV,matinh,diem,sobanthang,sobanthua,soluongcauthu) " + "values (' " + cmbMaDoi.Text + "', N'" + txtTenDoi.Text.Trim() + "', N'" + txtMaSan.Text.Trim() + "' , N'" + txtHLV.Text.Trim() + "', N'" + txtMaTinh.Text.Trim() + "',null,null,null,null)"; /*txtLogo.Text + "', N'" + ")"*/ MessageBox.Show(sql); DAO.LoadDataToTable(sql); DAO.CloseConnetion(); LoadDataToGriview(); } }
private void FrmTrandau_The_Load(object sender, EventArgs e) { DAO.OpenConnection(); LoadDataToGrivew(); DAO.CloseConnetion(); }
private void FrmCapNhatCT_Load(object sender, EventArgs e) { DAO.OpenConnection(); LoadDataToGrivew(); DAO.CloseConnetion(); }