public void hexinchuli(string riqi)
{
//链接到sql server数据库,将需要数据迁移到access数据库相应的表
string sqlserver = "Server =server;DataBase=database;Uid=sa;Pwd=123456";
string Access = "Provider = Microsoft.Jet.OleDb.4.0;Data Source = E://mymymy//backfile//" + riqi + ".mdb";
DataSet sqlds = new DataSet();
SqlConnection sqlconn = new SqlConnection(sqlserver);
sqlconn.Open();
System.IO.StringWriter sqlXML = new System.IO.StringWriter();
try
{
SqlDataAdapter mycommand = new SqlDataAdapter("select * from biao where syrp='"+riqi+"'", sqlconn);
mycommand.Fill(sqlds, "biao");
sqlds.WriteXml(sqlXML);
Syst