|
建立一个WinForm应用程序 添加MenuStrip控件,填写两个功能“读取” 和“导出数据”。
用了两个DataSet控件和对话框“打开(OpenFilesDialog控件)"和"保存(SaveFilesDialog控件)"
读取 private void 读取ToolStripMenuItem_Click(object sender, EventArgs e) { if (opFileDlg .ShowDialog() == DialogResult.OK) { if(opFileDlg .OpenFile()!=null) { twoXML .ReadXml (@opFileDlg .FileName ); foreach (DataRow twoRow in twoXML .Tables ["user"].Rows) { DataRow newRow = dsXML.Tables["user"].NewRow(); newRow ["序号"] = twoRow ["序号"]; newRow["标题"] = twoRow["标题"]; newRow["网址"] = twoRow["网址"]; newRow["用户名"] = twoRow["用户名"]; newRow["密码"] = twoRow["密码"]; newRow["时间"] = twoRow["时间"]; newRow["备注"] = twoRow["备注"]; dsXML .Tables ["user"].Rows .Add(newRow); } int n = dsXML .Tables ["user"].Rows .Count ; for(int i=0;i { dsXML .Tables ["user"].Rows [i]["序号"]=i+1; } dsXML.WriteXml(@"user.xml"); this.Visible = true; MessageBox.Show("数据导入成功!", "成功"); } } else { this.Visible = true; } }
导出 private void 导出ToolStripMenuItem_Click(object sender, EventArgs e) { if (svFileDlg.ShowDialog() == DialogResult.OK) { dsXML.WriteXml(@svFileDlg.FileName); this.Visible = true; MessageBox.Show("数据导出成功!", "成功"); } else { this.Visible = true; } }
|