数据库中添加成员.docVIP

添加成员按钮功能实现： private void button1_Click(object sender, EventArgs e) { string strcon = 系统.Properties.Settings.Default.tsfConnectionString; SqlConnection conn = new SqlConnection(strcon); conn.Open(); string sql1 = insert[Member] ([mnum],[mname],[msex],[mbranch],[mbedchamberNum],[tnum])values(@mnum,@mname,@msex,@mbranch,@mbed,@tnum); SqlCommand cmd = new SqlCommand(sql1, conn); cmd.Parameters.Add(@mnum, SqlDbType.Char, 2).Value = textBox6.Text.Trim(); cmd.Parameters.Add(@mname, SqlDbType.Char, 8).Value = textBox2.Text.Trim(); cmd.Parameters.Add(@msex, SqlDbType.Char, 2).Value = textBox3.Text.Trim(); cmd.Parameters.Add(@mbranch, SqlDbType.Char, 8).Value = textBox4.Text.Trim(); cmd.Parameters.Add(@mbed, SqlDbType.Char, 8).Value = textBox5.Text.Trim(); cmd.Parameters.Add(@tnum, SqlDbType.Char, 2).Value = textBox1.Text.Trim(); try { cmd.ExecuteNonQuery(); MessageBox.Show(保存成功！); this.Form4_Load(sender, e); } catch (Exception ex) { MessageBox.Show(出错！ + ex.Message); } finally { conn.Close(); } } private void radioButton1_CheckedChanged(object sender, EventArgs e) { } private void button3_Click(object sender, EventArgs e) { login form=new login(); form.Show(); this.Hide(); } private void button2_Click(object sender, EventArgs e) { string strcon = 系统.Properties.Settings.Default.tsfConnectionString; string check=; SqlConnection conn = new SqlConnection(strcon); string sql3 = select mnum from leader where tleader= + textBox2.Text + ;