导出数据: ----------------------------------------------- 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"); 另一种方法
比如备份Northwind
SQL: backup database Northwind to disk='c:/backuptext.dat'
所以程序这样写:
string myExecuteQuery = "backup database Northwind to disk='c:/backuptext.dat'"; SqlCommand myCommand = new SqlCommand(myExecuteQuery, myConnection); myCommand.Connection.Open(); myCommand.ExecuteNonQuery(); myConnection.Close(); |