C# (CSharp) QL_sinhvien KN.ExecuteNonquery_Pro示例

示例#1

        private void bt_sua_Click(object sender, EventArgs e)
        {
            string sql = " update tb_sinhvien set msv='" + tb_msv.Text + "', tensv=N'" + tb_tensv.Text + "',ngaysinh='" + dTP_ns.Text + "',gioitinh='" + ParseBool2string(rd1.Checked) + "',dienthoai='" + tb_dt.Text + "',diachi=N'" + tb_dc.Text + "',malop='" + cb_lop.Text + "'where msv='" + tb_msv.Text + "'";

            KN.ExecuteNonquery_Pro(sql);
            LoadData();
        }

示例#2

        private void bt_xoa_Click(object sender, EventArgs e)
        {
            string sql = "delete from tb_sinhvien where msv='" + tb_msv.Text + "'";

            KN.ExecuteNonquery_Pro(sql);
            LoadData();
        }