private void timer1_Tick(object sender, EventArgs e) { tssl3.Text = "现在时间:" + System.DateTime.Now.ToLongTimeString(); string time = dbl.Remindtime(); if (Convert.ToInt32(db.ExecuteSelect("select * from Remind where RemindTime='" + time + "'and IsRemind='是' and Statue='尚未提示'")) > 0) { DataSet ds = new DataSet(); ds = dbl.GetDataset("select * from Remind where RemindTime='" + time + "'"); string Reminid = Convert.ToString(ds.Tables[0].Rows[0][3]); //获得备忘表中的备忘记录 string type = Convert.ToString(ds.Tables[0].Rows[0][5]); if (type == "一次提醒") { db.ExeInfochange("update Remind set Statue='已经提示' where RemindTime='" + time + "'"); //更改提示的状态 } if (MessageBox.Show("\n 您有新的备忘: \n \n" + " " + Reminid + " ", "备忘提示", MessageBoxButtons.OK, MessageBoxIcon.Question) == DialogResult.Yes) { fmr.Refresh(); } } }