用DateSet读如xml文件

最新推荐文章于 2025-12-30 15:34:00 发布

原创最新推荐文章于 2025-12-30 15:34:00 发布 · 918 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#xml #dataset #string #encoding #schema #function

本文介绍了一种使用C#从XML文件中读取数据库连接信息的方法。通过FileStream和StreamReader加载名为conn.xml的文件，并将信息填充到DataSet中。随后，文章展示了如何从DataSet中提取hostname、catalog、user和password等关键字段。

用于连接数据库的xml文件(conn.xml)

<?xml version="1.0" encoding="utf-8" ?>
<conn>
<hostname>ZJG-C14616DC51A</hostname>
<catalog>government</catalog>
<user>sa</user>
<password>123</password>
</conn>

static void Main(string[] args)
{
DataSet ds=new DataSet();

   FileStream fs=new FileStream("conn.xml",FileMode.Open,FileAccess.Read);
   StreamReader reader=new StreamReader(fs);
   ds.ReadXml(reader);
   fs.Close();

   DataTable dt=ds.Tables[0];

   Console.WriteLine(dt.Rows[0]["hostname"]);
   Console.WriteLine(dt.Rows[0]["catalog"]);
   Console.WriteLine(dt.Rows[0]["user"]);
   Console.WriteLine(dt.Rows[0]["password"]);
   Console.Read();
  }

// Read the XML document back in.
   // Create new FileStream to read schema with.
   System.IO.FileStream fsReadXml = new System.IO.FileStream
      (xmlFilename, System.IO.FileMode.Open);
   // Create an XmlTextReader to read the file.
   System.Xml.XmlTextReader myXmlReader =
      new System.Xml.XmlTextReader(fsReadXml);
   // Read the XML document into the DataSet.
   newDataSet.ReadXml(myXmlReader);
   // Close the XmlTextReader
   myXmlReader.Close();

   // Print out values of each table in the DataSet using the
   // function defined below.
   PrintValues(newDataSet,"New DataSet");
}

private void PrintValues(DataSet ds, string label){
   Console.WriteLine("/n" + label);
   foreach(DataTable t in ds.Tables){
      Console.WriteLine("TableName: " + t.TableName);
      foreach(DataRow r in t.Rows){
         foreach(DataColumn c in t.Columns){
            Console.Write("/t " + r[c] );
         }
         Console.WriteLine();
      }
   }
}