private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "") { MessageBox.Show("输入能为空", "提示"); return; } if (textBox3.Text != "1" && textBox3.Text != "2" && textBox3.Text != "3") { MessageBox.Show("权限等级只能为(1,2,3)", "提示"); return; } DBcon DB = new DBcon(); string str = "insert into Table_users values ('" + textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "')"; try { DBcon.GetCon(); DB.ExecuteUpdate(str); MessageBox.Show("添加成功!"); } catch (Exception ex) { MessageBox.Show(ex.Message, "错误"); } finally { DB.Con_Close(); } }
private void button2_Click(object sender, EventArgs e) { DBcon con = new DBcon(); if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("请先输入要添加的信息!"); return; } try { string str = "insert into Students values ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "')"; DBcon.GetCon(); DBcon DB = new DBcon(); DB.ExecuteUpdate(str); MessageBox.Show("插入成功!"); } catch (Exception ex) { MessageBox.Show(ex.Message, "提示"); } finally { con.Con_Close(); } }