.NET的dataset是一个很有趣的对象,借助与XML可以很快捷的做出数据导入,导出功能.microsoft-com:Office:office" />
关键代码如下:
///
/// export the table of database
///
/// table name
/// file path
/// Connection of database
///
public bool ExportTableToXml(string m_TableName,string m_FilePath,OledbConnection m_PubConn)
{
try
{
DataSet ds = new DataSet();
OleDbDataAdapter m_Adapter = new OleDbDataAdapter("",m_PubConn);
m_Adapter.selectCommand = new OleDbCommand("select * from "+m_TableName,m_PubConn);
m_Adapter.Fill(ds,m_TableName);
System.IO.FileStream fs = new System.IO.FileStream(m_FilePath,System.IO.FileMode.Create);
ds.WriteXml(fs, XmlWriteMode.WriteSchema);
fs.Close();
return true;
}catch (System.Exception error)
{
MessageBox.Show(error.Message,"error",MessageBoxButtons.OK,MessageBoxIcon.Error);
return false;
}
}
///
/// import the xml file to database
///
/// file path
/// table name
/// connection of database
///
public bool ImportXmlToTable(string m_FilePath,string m_TableName,OleDbConnection m_PubConn)
{
try
{
DataSet ds = new DataSet();
DataSet mdsMain = new DataSet();
OleDbCommand m_Comm = new OleDbCommand("",m_PubConn);
OleDbDataAdapter m_Adapter = new OleDbDataAdapter();
mdsMain.ReadXml(m_FilePath,XmlReadMode.ReadSchema);
//delete from tablename
m_Comm.CommandText = "delete from "+m_TableName;
m_Comm.ExecuteNonQuery();
//set the m_Adapter
m_Comm.CommandText = "select * from "+m_TableName;
m_Adapter.SelectCommand = m_Comm;
OleDbCommandBuilder cb = new OleDbCommandBuilder(m_Adapter);
m_Adapter.Fill(ds,m_TableName);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
mdsMain.WriteXml(ms, XmlWriteMode.DiffGram);
ms.Seek(0, SeekOrigin.Begin);
ds.ReadXml(ms, XmlReadMode.DiffGram);
m_Adapter.Update(ds, m_TableName);
ds.AcceptChanges();
ms.Close();
return true;
}catch(System.Exception error)
{
MessageBox.Show(error.Message.ToString(),"error",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
return false;
}
}
测试代码:
private void button1_Click(object sender, System.EventArgs e)
{
ExportTableToXml("T_FieldSet","c:xx.xml",m_PubConn);
ExportTableToXml("T_FieldItem","c:yy.xml",m_PubConn);
MessageBox.Show("success");
}
private void button2_Click(object sender, System.EventArgs e)
{
ImportXmlToTable("c:xx.xml","T_FieldSet",m_PubConn);
ImportXmlToTable("c:yy.xml","T_FieldItem",m_PubConn);
MessageBox.Show("success");
}
注意:
1. 我在导入数据的时候,将原来的数据删除了的;
2. 2个函数导入,导出只是针对单个表;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10752019/viewspace-959006/ ，如需转载，请注明出处，否则将追究法律责任。
