1: using System;

   2: using System.Timers;

   3:  

   4: static void Main(string[] args)

   5: {

   6:     BeginSchedule();

   7:     Console.ReadKey();

   8: }

   9:  

  10: private static void BeginSchedule()

  11: {

  12:     var timer = new Timer

  13:                     {

  14:                         // Gap between each event execution

  15:                         // set to 5 seconds in miliseconds.

  16:                         // Then timer is started.

  17:                         Interval = 5000,

  18:                         Enabled = true

  19:                     };

  20:  

  21:     // Event that is called after each timer interval.

  22:     timer.Elapsed += new ElapsedEventHandler(TimerElapsedEvent);

  23: }

  24:  

  25: static void TimerElapsedEvent(object sender, ElapsedEventArgs e)

  26: {

  27:     Console.WriteLine("5 seconds later.");

  28: }

   1: using System;

   2: using System.Collections.Generic;

   3: using System.IO;

   4: using System.Text;

   5:  

   6: private static void CreateCsvFile()

   7: {

   8:     var filePath = @"C:\Books.csv";

   9:  

  10:     // Initialise stream object with file

  11:     using (var wr = new StreamWriter(filePath, true))

  12:     {

  13:         // Collection of book titles

  14:         var row = new List<string> 

  15:             {"A Game of Thrones", "A Clash of Swords", "A Feast for Crows", "A Dance with Dragons"};

  16:  

  17:         var sb = new StringBuilder();

  18:  

  19:         foreach (string value in row)

  20:         {

  21:             // Add a comma before each string

  22:             // this adds a comma before the book title

  23:             if (sb.Length > 0)

  24:                 sb.Append(",");

  25:  

  26:             sb.Append(value);

  27:         }

  28:  

  29:         // write output to file

  30:         wr.WriteLine(sb.ToString());

  31:     }

  32: }

   1: using System.IO;

   2: using System.Net;

   3:  

   4: static void Main(string[] args)

   5: {

   6:     // Initialise new WebClient object to send request

   7:     var client = new WebClient();

   8:  

   9:     // Add the QueryString parameters as Name Value Collections

  10:     // that need to go with the HTTP request, the data being sent

  11:     client.QueryString.Add("id", "00001");

  12:     client.QueryString.Add("author", "Harish Mathanan");

  13:     client.QueryString.Add("tag", "Programming");

  14:  

  15:     // Prepare the URL to send the request to

  16:     string url = "http://somerandomsite.com";

  17:  

  18:     // Send the request and read the response

  19:     var stream = client.OpenRead(url);

  20:     var reader = new StreamReader(stream);

  21:     var response = reader.ReadToEnd().Trim();

  22:  

  23:     // Clean up the stream and HTTP connection

  24:     stream.Close();

  25:     reader.Close();

  26: }

   1: public void btnUpload_Click(object sender, EventArgs e)

   2: {

   3:     string conn = ConfigurationManager.ConnectionStrings["SampleDB"].ConnectionString;

   4:  

   5:     // FIRST PART: 

   6:     // get the uploded picture into a byte[] array

   7:     // from the FileUpload control (photoUpload)

   8:     byte[] content = new byte[this.photoUpload.PostedFile.InputStream.Length];

   9:     this.photoUpload.PostedFile.InputStream.Read(content, 0, content.Length);

  10:  

  11:     // SECOND PART:

  12:     // save the byte[] into the database image type

  13:     using (SqlConnection dbConn = new SqlConnection(conn))

  14:     {

  15:         dbConn.Open();

  16:         using (SqlCommand cmd = new SqlCommand("InsertNewPhoto", dbConn))

  17:         {

  18:             cmd.CommandType = CommandType.StoredProcedure;

  19:             cmd.Parameters.Add("@photo", SqlDbType.Image);

  20:             cmd.Parameters["@photo"].Value = content;

  21:  

  22:             cmd.ExecuteNonQuery();

  23:         }

  24:     }

  25: }

   1: protected void Page_Load(object sender, EventArgs e)

   2: {

   3:     if (!this.Page.IsPostBack)

   4:     {

   5:         this.photoImage.ImageUrl = "Photo.ashx";

   6:     }

   7: }

   1: public void ProcessRequest(HttpContext context)

   2: {

   3:     // REAL WORLD:

   4:     // Retrieve an id that has been passed into a querystring.

   5:     // the id is then passed to the database to retrieve the relevant

   6:     // photo.

   7:  

   8:  

   9:     // This example passes in just the one particular value all the time.

  10:     byte[] content = null;

  11:     context.Response.ContentType = "image/jpeg";

  12:     context.Response.Clear();

  13:  

  14:     string conn = ConfigurationManager.ConnectionStrings["SampleDB"].ConnectionString;

  15:  

  16:     using (SqlConnection dbConn = new SqlConnection(conn))

  17:     {

  18:         dbConn.Open();

  19:         using (SqlCommand cmd = new SqlCommand("SelectPhotoById", dbConn))

  20:         {

  21:             cmd.CommandType = CommandType.StoredProcedure;

  22:             cmd.Parameters.Add("@photoId", SqlDbType.Int);

  23:             cmd.Parameters["@photoId"].Value = 1; // constant value being passed in

  24:  

  25:             using (SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.SingleResult))

  26:             {

  27:                 while (rdr.Read())

  28:                 {

  29:                     content = (byte[])rdr["Photo"];

  30:                 }

  31:             }

  32:  

  33:         }

  34:     }

  35:  

  36:     context.Response.BinaryWrite(content);

  37:  

  38: }