建立一个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<n;i++)
{
dsXML .Tables ["user"].Rows [i]["序号"]=i+1;
}
dsXML.WriteXml(@"user.xml");
this.Visible = true;
MessageBox.Show("数据导入成功!", "成功");
}
}
else
{
this.Visible = true;
}
}
{
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<n;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;
}
}
{
if (svFileDlg.ShowDialog() == DialogResult.OK)
{
dsXML.WriteXml(@svFileDlg.FileName);
this.Visible = true;
MessageBox.Show("数据导出成功!", "成功");
}
else
{
this.Visible = true;
}
}