〖导出数据: --------------...... 导出数据: ----------------------------------------------- DataSet ds = new DataSet(); SqlConnection conn = new SqlConnection("server = localhost;uid=sa;pwd=1qaz2wsx;database=test"); conn.Open(); SqlCommand comm = null; comm = new SqlCommand(@"SELECT * FROM person",conn); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = comm; da.Fill(ds,"table"); ds.WirteXml(@"C://a.xml",XmWriteMode.WriteSchema); ------------------------------------------------------- 恢复数据: DataSet dsEx = new DataSet(); dsEx.ReadXml(@"c://a.xml",XmlReadMode.ReadSchema); foreach (DataRow d2r in ds.Tables["table"].Rows) { d2r.Delete(); } da.Update(ds,"table"); ds = dsEx.Copy(); da.Update(ds,"table"); |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 23:24 , Processed in 0.119441 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.