private void toolStripButton4_Click(object sender, EventArgs e) { if (MysqlHelper.IsConnected()) { MessageBox.Show("连接成功"); } else { MessageBox.Show("连接失败"); } }
private void toolStripButton5_Click(object sender, EventArgs e) { List <string> list = new List <string>(); string result = ""; list = MysqlHelper.DataReaderTest(); foreach (string item in list) { result += item + "\n"; } MessageBox.Show(result); }
private void toolStripButton6_Click(object sender, EventArgs e) { DataSet myData = MysqlHelper.DataSetTest(); foreach (DataTable table in myData.Tables) { foreach (DataRow row in table.Rows) { foreach (object field in row.ItemArray) { MessageBox.Show(field.ToString()); } } } }
//载入文件菜单 public void LoadReadHistory() { IList <string> list = new List <string>(); DataSet filedata = MysqlHelper.SelectData(); foreach (DataRow row in filedata.Tables[0].Rows) { list.Add(row["path"].ToString()); } toolStripMenuItem1.DropDownItems.Clear(); toolStripMenuItem1.DropDownItems.Insert(0, 打开ToolStripMenuItem); toolStripMenuItem1.DropDownItems.Insert(1, toolStripSeparator1); toolStripMenuItem1.DropDownItems.Insert(2, 退出ToolStripMenuItem); toolStripMenuItem1.DropDownItems.Insert(3, 清除ToolStripMenuItem); if (list.Count > 0) { for (int i = 0; i < list.Count; i++) { ToolStripMenuItem menu = new ToolStripMenuItem(list[i]); toolStripMenuItem1.DropDownItems.Insert(i + 1, menu); menu.Click += menu_Click; } } }
//退出按钮 private void 退出ToolStripMenuItem_Click(object sender, EventArgs e) { MysqlHelper.UpdatePage(filename, page); MysqlHelper.MysqlClose(); Close(); }
//清除按钮 private void 清除ToolStripMenuItem_Click(object sender, EventArgs e) { MysqlHelper.DeleteData(); LoadReadHistory(); }
private void Form1_Load(object sender, EventArgs e) { //载入阅读历史 LoadReadHistory(); MysqlHelper.MysqlOpen(); }