private void button1_Click(object sender, EventArgs e) { num--; if (num >= 0) { Process.Text = num.ToString(); string[] str = textBox1.Text.Split("\n".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); string sql = "delete from MyWordsNote where [English] ='" + str[0] + "'"; AccessHelper.ExecuteSql(sql); MessageBox.Show(AccessHelper.ExecuteSql(sql).ToString()); Random rand = new Random(DateTime.Now.Millisecond); string sql1 = "select count(*) from MyWordsNote"; int count = int.Parse(AccessHelper.QuerybySql(sql1)); if (count >= 1) { int id = rand.Next(1, count + 1); string sql_ch = "select Chinese from MyWordsNote where ID =" + id; string sql_en = "select English from MyWordsNote where ID =" + id; textBox1.Text = AccessHelper.QuerybySql(sql_en) + "\r\n" + AccessHelper.QuerybySql(sql_ch); } } else { MessageBox.Show("单词已经背完"); } }
public void button1_Click(object sender, EventArgs e) { int num = 0; string sql = "update CET4 set [Note]='" + textBox1.Text + "'" + "where English='" + SearchBox.Text + "'"; num = AccessHelper.ExecuteSql(sql); if (num == 1) { MessageBox.Show("添加笔记成功"); } else { MessageBox.Show("添加笔记失败"); } }
public void Save_Click(object sender, EventArgs e) { string sql = "insert into MyWordsNote ([English],[Chinese],[Note]) values ('" + SearchBox.Text + "','" + textBox2.Text + "','" + textBox1.Text + "')"; string sql1 = "select count(*) from MyWordsNote where English = '" + SearchBox.Text + "'"; if (int.Parse(AccessHelper.QuerybySql(sql1)) >= 1) { MessageBox.Show("该单词已经存在"); } else { int num = AccessHelper.ExecuteSql(sql); if (num > 0) { MessageBox.Show("收藏成功"); } else { MessageBox.Show("收藏失败"); } } }