| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141 |
- From main.cs
- #region Test
- /**********************************************TEST ......................
- /// <summary>
- /// Test lecture xml imbriqué
- /// </summary>
- private void tt()
- {
- //XElement xEle = new XElement("tb_prestas", "content");//XElement.Load(Program.folder + @"\employees.xml");
- //IEnumerable<XElement> employees = xelement.Elements();
- //// Read the entire XML
- //foreach (var employee in employees)
- //{
- // Console.WriteLine("***********");
- // Console.WriteLine(employee);
- //}
- //XElement xEle = XElement.Load("..\\..\\Employees.xml");
- XElement sxEle = new XElement("Employee",
- new XElement("EmpId", 6),
- new XElement("Name", "George"),
- new XElement("Sex", "Male"),
- new XElement("Phone", "423-555-4224", new XAttribute("Type", "Home")),
- new XElement("Phone", "424-555-0545", new XAttribute("Type", "Work")),
- new XElement("Address",
- new XElement("Street", "Fred Park, East Bay"),
- new XElement("City", "Acampo"),
- new XElement("State", "CA"),
- new XElement("Zip", "95220"),
- new XElement("Country", "USA")));
- XElement xEle = new XElement("tb_prestas", sxEle);
- xEle.Save(Program.folder + @"\employees2.xml");
- Console.WriteLine(xEle);
- }
- **********************************************************/
- #endregion Test
- /*
- *
- List<string> linesGlob = lines.FindAll(
- delegate(string sr)
- {
- return sr.ToUpper().Contains(".GLOBAL.");
- }
- );
- List<string> linesUnik = lines.FindAll(
- delegate(string sr)
- {
- return !sr.ToUpper().Contains(".GLOBAL.");
- }
- );
- foreach (string line in linesGlob)
- readHttp_Glob(line);
- foreach (string line in linesUnik)
- readHttp_Unik(line);
- *
- private void readHttp_Glob(string url_txt)
- {
- Uri url = new Uri(url_txt);
- HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
- request.MaximumAutomaticRedirections = 4;
- request.MaximumResponseHeadersLength = 4;
- request.Credentials = CredentialCache.DefaultCredentials;
- HttpWebResponse response = (HttpWebResponse)request.GetResponse();
- Stream receiveStream = response.GetResponseStream();
- StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8);
- streamtolist_glob(readStream);
- readStream.Close();
- response.Close();
- }
- private void readHttp_Unik(string url_txt)
- {
- Uri url = new Uri(url_txt);
- HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
- request.MaximumAutomaticRedirections = 4;
- request.MaximumResponseHeadersLength = 4;
- request.Credentials = CredentialCache.DefaultCredentials;
- HttpWebResponse response = (HttpWebResponse)request.GetResponse();
- Stream receiveStream = response.GetResponseStream();
- StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8);
- streamtolist_uniq(readStream);
- response.Close();
- readStream.Close();
- }
- //Make Images
- private void makePnpFromDB()
- {
- //the index number to write bytes to
- long CurrentIndex = 0;
- //the number of bytes to store in the array
- int BufferSize = 4096;
- //The Number of bytes returned from GetBytes() method
- long BytesReturned;
- //A byte array to hold the buffer
- byte[] Blob = new byte[BufferSize];
- string strCnx="server=localhost;user id=Patrick;password=xvtu92+2;persist security info=True;database=carbu";
- MySql.Data.MySqlClient.MySqlConnection myCnx = new MySql.Data.MySqlClient.MySqlConnection(strCnx);
- myCnx.Open();
- string strCmd = "select * from pays";
- MySql.Data.MySqlClient.MySqlCommand myCmd = new MySqlCommand(strCmd,myCnx);
- MySqlDataReader myReader = myCmd.ExecuteReader();
- while ( myReader.Read())
- {
- listBox1.Items.Add(myReader.GetString(0));
- FileStream fs = new FileStream("D:\\temp\\" + myReader.GetString(0)+"_"+ myReader.GetString(1)+"_"+ myReader.GetString(2).Replace(" ","")+".png", FileMode.OpenOrCreate, FileAccess.Write);
- BinaryWriter writer = new BinaryWriter(fs);
- CurrentIndex = 0;
- BytesReturned = myReader.GetBytes(3, CurrentIndex, Blob, 0, BufferSize);
- while (BytesReturned == BufferSize)
- {
- writer.Write(Blob);
- writer.Flush();
- CurrentIndex += BufferSize;
- BytesReturned = myReader.GetBytes(3, CurrentIndex, Blob, 0, BufferSize);
- }
- writer.Write(Blob, 0, (int)BytesReturned);
- writer.Flush();
- writer.Close();
- fs.Close();
- }
- myReader.Close();
- myCnx.Close();
- }
- */
|