private void DatabaseConnection()
{
OleDbConnection conn = null;
//OleDbDataReader reader = null;
try
{
conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + Server.MapPath("rb_workord.mdb"));
conn.Open(); }
    catch (Exception e)
    {
         Response.Write(e.Message);
          Response.End();
    }
}
private void menuItem2_Click(object sender, System.EventArgs e)
{
Page_Load(sender, e);
} private void SolverExecuation(object sender, System.EventArgs e)
{

string InputXML = "InputData.xml";
string InputXMLSchema = "InputData.xsd";

try
{
//fs = new FileStream(InputXML, FileMode.Create);
//writer = new StreamWriter(fs);
//Today
DatabaseConnection();
DataSet dataSetOrderShopMaInfo = new DataSet();
OleDbDataAdapter adapterToday  = new OleDbDataAdapter("SELECT Today, LeadTime FROM nqry_Today", conn);
adapterToday.Fill(dataSetOrderShopMaInfo, "nqry_Today");

//Order Info
OleDbDataAdapter adapterOrder  = new OleDbDataAdapter("SELECT SHOP_NO, PART_NO, OP_NO, QTY_MFG, GOOD, OPERATIONCOST, DUE_DATE, DUE_DATE2, JOBSTATUS FROM nqry_WorkOrdr_OnSchedule ORDER BY SHOP_NO, OP_NO DESC", conn);
adapterOrder.Fill(dataSetOrderShopMaInfo, "nqry_WorkOrdr_OnSchedule");

//Shop Hours
OleDbDataAdapter adapterShopHours  = new OleDbDataAdapter("SELECT DEPT_NO, DAYSPERWEEK1, START1, STOP1, MM1, MAXSETUP1, DAYSPERWEEK2, START2, STOP2, MAXSETUP2, MM2, DAYSPERWEEK3, START3, STOP3, MM3, MAXSETUP3 FROM nqry_Shop_Hours", conn);
adapterShopHours.Fill(dataSetOrderShopMaInfo, "nqry_Shop_Hours"); //Routine
OleDbDataAdapter adapterRoutine  = new OleDbDataAdapter("SELECT PART_NO, OP_NO, MACH_NO, ACT_SETUPOfFirst, ACT_RATEOfFirst, SPLIT, BATCHSIZE FROM nqry_Routing_Machine_OnSchedule ORDER BY PART_NO, OP_NO, MACH_NO", conn);
adapterRoutine.Fill(dataSetOrderShopMaInfo, "nqry_Routing_Machine_OnSchedule"); //Machine-Department
OleDbDataAdapter adapterMacDep  = new OleDbDataAdapter("SELECT MACH_NO, DEPT_NO, MIN_UTILIZATION, MAX_UTILIZATION, IGNORED, Labor1, Labor2, Labor3 FROM nqry_Mach_Dept", conn);
adapterMacDep.Fill(dataSetOrderShopMaInfo, "nqry_Mach_Dept"); //BOM
OleDbDataAdapter adapterBOM  = new OleDbDataAdapter("SELECT SHOP_NO, PRE FROM tbl_BOM", conn);
adapterBOM.Fill(dataSetOrderShopMaInfo, "tbl_BOM"); dataSetOrderShopMaInfo.WriteXmlSchema(InputXMLSchema);

XmlTextReader xmlReaderDS61 = new XmlTextReader(dataSetOrderShopMaInfo.GetXml(), XmlNodeType.Element, null); XmlTextWriter xmlWriterDS61 = new XmlTextWriter(InputXML,System.Text.Encoding.UTF8); xmlWriterDS61.WriteStartDocument();

string elementName = "";

// Parse and display each node.
while(xmlReaderDS61.Read())
{
switch(xmlReaderDS61.NodeType)
{
case XmlNodeType.Element:
xmlWriterDS61.WriteStartElement(xmlReaderDS61.Name);
elementName = xmlReaderDS61.Name;
break;
case XmlNodeType.Text:
if (elementName.Length >= 8 && elementName.ToLower().Substring(0, 8) == "due_date")
{
xmlWriterDS61.WriteString(Convert.ToInt32(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("d"));
}
else if (elementName.Length >= 5 && elementName.ToLower().Substring(0,5) == "start")
xmlWriterDS61.WriteString(Convert.ToDouble(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("F2"));
else if (elementName.Length >= 4 && elementName.ToLower().Substring(0,4) == "stop")
xmlWriterDS61.WriteString(Convert.ToDouble(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("F2"));
else if (elementName.ToLower() == "today")
xmlWriterDS61.WriteString(Convert.ToInt32(XmlConvert.ToDateTime(xmlReaderDS61.Value).ToOADate()).ToString("d"));
else
xmlWriterDS61.WriteString(xmlReaderDS61.Value);
break;
case XmlNodeType.EndElement:
xmlWriterDS61.WriteEndElement();
break;
} //MessageBox.Show(XmlNodeType.EndElement.ToString());
//if (XmlNodeType.EndElement == xmlReader.NodeType) 
//{
// xmlReader.ResetState();
//}
}
xmlWriterDS61.Close(); xmlReaderDS61.Close(); //dataSetOrderShopMaInfo.WriteXml(writer);
dataSetOrderShopMaInfo.Clear();
//odbcDataAdapter9.Fill(dataSet61);
//dataSet61.WriteXml(writer); }
catch(Exception excep)
{
Response.Write(excep.ToString());
}
finally
{
//writer.Flush();
//writer.Close();
//fs.Close();
} }上面一段话编译的时候报错,,不知道为什么!