请高手指点！

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();  
  }  
   
  }  
   
  上面一段话编译的时候报错，，不知道为什么！ 问题点数：100、回复次数：2Top

1 楼crane_9999（渴望失败！）回复于 2006-06-04 03:15:09 得分 100

晕，，这么多，，你加入using   System.Xml.Xsl;  
  using   System.Xml.XPath;  
  using   System.Data.OleDb;  
  using   System.Diagnostics;   试试！Top

2 楼crane_crane（）回复于 2006-06-04 03:17:22 得分 0

xiexie       lou   shangdeTop

相关问题

• 帖主：crane_crane
• crane_9999

• CSDN .NET频道
• .NET类图书
• C#类图书
• .NET类源码下载