C#

using System;
using System.IO;
using System.Net;
using System.Text;

namespace Examples.System.Net
{
    public class WebRequestGetExample
    {
        public static void Main ()
        {
            // Create a request for the URL. 		
            WebRequest request = WebRequest.Create ("http://www.contoso.com/default.html");
            // If required by the server, set the credentials.
            request.Credentials = CredentialCache.DefaultCredentials;
            // Get the response.
            HttpWebResponse response = (HttpWebResponse)request.GetResponse ();
            // Display the status.
            Console.WriteLine (response.StatusDescription);
            // Get the stream containing content returned by the server.
            Stream dataStream = response.GetResponseStream ();
            // Open the stream using a StreamReader for easy access.
            StreamReader reader = new StreamReader (dataStream);
            // Read the content.
            string responseFromServer = reader.ReadToEnd ();
            // Display the content.
            Console.WriteLine (responseFromServer);
            // Cleanup the streams and the response.
            reader.Close ();
            dataStream.Close ();
            response.Close ();
        }
    }
}

Bastard Programmer from Hell

DateTime dt1 = DateTime.Parse("01/12/2005");
DateTime dt2 = DateTime.Parse("Dec 12 2005");
TimeSpan diff = dt2 - dt1;

DateTime dt1 = DateTime.Parse("firstDate");
DateTime dt2 = DateTime.Parse("secondDate");
TimeSpan dateDifference = dt1.Subtract(dt2);

using(SqlConnection conn = new SqlConnection("..."))
using(SqlCommand cmd = new SqlCommand("...", conn))
{
   cmd.Parameters.AddWithValue("@date", date_value);
   cmd.ExecuteNonQuery();
}