C#

ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(ValidateServerCertificate);

private bool ValidateServerCertificate(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors)
{
    bool result = true;
    // Examine sslPolicyErrors here and set result accordingly.
    return result;
}

using System.Net;
using System.Net.Security;
using System.Security.Cryptography.X509Certificates;

SELECT 
    customerName,
    createDate
FROM
   customer
WHERE 
   createDate BETWEEN '2009-10-01' AND '2009-10-31'
UNION 
SELECT
    employeeName,
    hireDate
FROM
    employee
WHERE
   hireDate BETWEEN '2009-10-01' AND '2009-10-31'

datatable1 = datatable2.Copy();

norjali wrote:

i wont be able to use foreach or for loop (i think)as some of the rows are not in order ?