using System;
using System.Xml;
using System.Data;
using System.Data.SqlClient;

namespace XML
{
	/// <summary>
	/// Class1 的摘要說(shuō)明。
	/// </summary>
	public class XMLOpp
	{
		static string path;
		public XMLOpp()
		{
			 
		}
		[STAThread]
         
		static void Main(string []args)
		{
			path="c:\\books.xml";
			XmlTextRead(path);
		}

		/// <summary>
		/// 流模式讀取XML文件
		/// </summary>
		/// <param name="path"></param>
		public static void XmlTextRead(string path)
		{
                 
			try
			{
				XmlTextReader xr=new XmlTextReader(path);
				

				while(xr.Read())
				{                    //先有值，后為空
					if(xr.NodeType==XmlNodeType.Element && xr.Name=="author")  //一定要子節(jié)點(diǎn)才可以訪問(wèn)到值，換句話就是標(biāo)簽之間有值
					{  
						xr.MoveToAttribute("author");                          //移到屬性節(jié)點(diǎn)的name上
						Console.WriteLine(xr.ReadString());
						xr.MoveToElement();
					}
 
				}
               
//                 xr=new XmlTextReader(path);
//
//				while(xr.Read())
//				{
//					if(xr.NodeType==XmlNodeType.Element && xr.Name == "author")
//					{   
//						    //轉(zhuǎn)到該元素
//                        xr.MoveToAttribute("author"); 
////						Console.WriteLine("xr.Value:"+xr.Value);
////						Console.WriteLine(xr.ReadString());
//						if(xr.ReadString()=="A")
//						{   
//							//轉(zhuǎn)到該元素
//                            xr.MoveToElement(); 
//							Console.WriteLine(xr.ReadInnerXml());
//						}
//                       
//					}
//
//				}

			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.ToString());
			}
			finally
			{
				Console.ReadLine();
			}
		}

        
		/// <summary>
		/// 寫入XML文件
		/// </summary>
		/// <param name="path"></param>

		public static void XMLTextWrite(string path)
		{
            XmlTextWriter xw=new XmlTextWriter(path,System.Text.Encoding.ASCII);
			try
			{
               xw.WriteStartDocument();
			   xw.WriteStartElement("books");//結(jié)構(gòu)一定要全
			   xw.WriteStartElement("book");

//				xw.WriteAttributeString("author","zong");   //Attribute是屬性的意思
//				xw.WriteAttributeString("price","33");    //寫入一定是string類型的
				xw.WriteElementString("author","zong");
				xw.WriteElementString("price","33");
				
				xw.WriteEndElement();				
				xw.WriteEndElement();
				xw.WriteEndDocument();
				

                xw.WriteStartElement("books");
				
				xw.WriteStartElement("book");                
				xw.WriteAttributeString("publish","nanjing");
				xw.WriteElementString("author","li");
				xw.WriteElementString("price","33");
				xw.WriteEndElement();
                
				xw.WriteEndElement();




				xw.Flush();				
				xw.Close();
 
			}
			catch(Exception ex)
			{
                Console.WriteLine(ex.ToString());
			}
			finally
			{
				Console.ReadLine();
			}
            





		}

	 
        
    
        /// <summary>
        /// 把DataSet轉(zhuǎn)化為XML文件
        /// </summary>
        /// <param name="thisDataSet"></param>
		private static void WriteXmlToFile(DataSet thisDataSet) 
		{ 
			try
			{
				if (thisDataSet == null) { return; } 

				// Create a file name to write to. 
				string filename = "C:\\myXmlDoc.xml"; 

				// Create the FileStream to write with. 
				System.IO.FileStream myFileStream = new System.IO.FileStream 
					(filename, System.IO.FileMode.Create); 

				// Create an XmlTextWriter with the fileStream. 
				System.Xml.XmlTextWriter myXmlWriter = 
					new System.Xml.XmlTextWriter(myFileStream, System.Text.Encoding.Unicode); 

				// Write to the file with the WriteXml method. 
				thisDataSet.WriteXml(myXmlWriter); 

				myXmlWriter.Close(); 
			}
			catch(Exception ex)
			{
                Console.WriteLine(ex.ToString());      
			}
		} 


	   /// <summary>
	   /// 產(chǎn)生DataSet函數(shù)
	   /// </summary>
	   /// <returns></returns>
		public static DataSet StudentDataSet()
		{    
			
                                                                            			DataSet ds=new DataSet();	
			SqlConnection conn=new SqlConnection();
			SqlDataAdapter da=new SqlDataAdapter();
			try
			{
				string ConnectionString="Server=(local);User id=sa;Pwd=123;Database=zong"; 
				conn=new SqlConnection(ConnectionString);             
				SqlCommand comm=new SqlCommand();
				conn.Open();
				comm.Connection=conn;
				comm.CommandText="select * from student";
				
				da=new SqlDataAdapter(comm);
				
				da.Fill(ds);
				 

			}
			catch(Exception ex)
			{
				Console.WriteLine(ex.ToString());             
			}
			finally
			{
				conn.Close();
			}

			return ds;

		}
	





	}
}