private void NewOK_Click(object sender, EventArgs e) { if (NewContent.Text != "") { sql = new SqlHelp("data source=mydb.db"); sql.CreateTable("fenzu", new string[] { "Name" }, new string[] { "TEXT" }); sql.InsertValues("fenzu", new string[] { NewContent.Text }); sql.CloseConnection(); MessageBox.Show("添加成功!"); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("分组名称不能为空!"); } }
private void OK_Click(object sender, EventArgs e) { if (tname.Text.Trim() == "") { MessageBox.Show("姓名不能为空!"); } else if (tfenlei.Text.Trim().Length == 0) { MessageBox.Show("请务必选择分组"); } else { name = tname.Text; if (tphone.Text.Trim() != "") { phone = tphone.Text; } if (temail.Text.Trim() != "") { email = temail.Text; } if (tqq.Text.Trim() != "") { qq = tqq.Text; } if (tweixin.Text.Trim() != "") { weixin = tweixin.Text; } if (tbeizhu.Text.Trim() != "") { beizhu = tbeizhu.Text; } fenlei = tfenlei.SelectedItem.ToString(); sql = new SqlHelp("data source=mydb.db"); sql.InsertValues("tongxunlu", new string[] { name, phone, fenlei, email, qq, weixin, beizhu }); MessageBox.Show("添加成功"); sql.CloseConnection(); this.DialogResult = DialogResult.OK; this.Close(); } //MessageBox.Show(name); }