/*
* private void addStudentFrm_FormClosing(object sender, FormClosingEventArgs e)
* {
* DialogResult = DialogResult.OK;
* }*/
private void button1_Click(object sender, EventArgs e)
{
if (txtID.Text != "")
{
//string sql = "insert into student(sno,sname,ssex,sclass,zno,spsw,Admission_time,Graduation_time,inschool) values('" + txtID.Text + "','" + txtName.Text + "','" + comboSex.SelectedItem + "','" + txtclass.Text + "','" + txtzno.Text + "','123','" + dateTime.Value + "','" + dateTime1.Value + "','" + comboBox1.SelectedItem + "')";
string sql = "insert into student(sno,sname,ssex,sclass,zno,spsw,Admission_time,Graduation_time,inschool)values ('" + txtID.Text + "','" + txtName.Text + "','" + comboSex.SelectedItem + "','" + txtclass.Text + "','" + txtzno.Text + "','123','" + dateTime.Value + "','" + dateTime1.Value + "','" + comboBox1.SelectedItem + "')";
if (op.OPSQL(sql))
{
//ClearText();
MessageBox.Show("新建成功！");
}
else
{
MessageBox.Show("创建失败！");
}
}
else
{
MessageBox.Show("信息输入不全！");
}
}
/*
* private void addStudentFrm_FormClosing(object sender, FormClosingEventArgs e)
* {
* DialogResult = DialogResult.OK;
* }*/
private void button1_Click(object sender, EventArgs e)
{
if (txtID.Text != "")
{
string sql = "insert into student(sno,sname,ssex,date,nation,nativeplace,grade,profession,scholarship) values('" + txtID.Text + "','" + txtName.Text + "','" + comboSex.SelectedItem + "','" + dateTime.Value + "','" + txtNation.Text + "','" + txtNative.Text + "','" + txtScore.Text + "','" + comboMajor.SelectedItem + "','" + txtGrant.Text + "')";
if (op.OPSQL(sql))
{
//ClearText();
MessageBox.Show("新建成功！");
}
else
{
MessageBox.Show("创建失败！");
}
}
else
{
MessageBox.Show("信息输入不全！");
}
}
private void button5_Click(object sender, EventArgs e)
{
string sql = "update student SET inschool=0 where Graduation_time<getdate()";
if (op.OPSQL(sql))
{
//ClearText();
MessageBox.Show("更改成功！");
}
else
{
MessageBox.Show("更改失败失败！请重试！");
}
}
