private void button2_Click(object sender, EventArgs e)
{
Mainform main = new Mainform();
main.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)//添加信息
{
string str = @"Data Source=desktop-mbupc0n;Initial catalog=学生信息管理系统;integrated Security=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string insert1 = "insert into student(学号,姓名,性别,身份证号,学制,班级,专业,入学时间,地址,电话,邮编) values('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox11.Text
+ "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox10.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + textBox7.Text + "')";
SqlCommand cmd = new SqlCommand(insert1, conn);//SqlCommand对象允许你指定在数据库上执行的操作的类型。
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("添加成功");
this.Hide();
Mainform form = new Mainform();
form.Show();
}
else
{
MessageBox.Show("添加失败");
}
}
