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);
}
