private void button1_Click(object sender, EventArgs e)
    {
        DataTable dt = null;

        SqlOMS2 sqlOMS2 = new SqlOMS2();

        Stopwatch sw = new Stopwatch();
        sw.Start();
        int num = 100;

        for (int i = 0; i < num; i++)
        {
            sqlOMS2.GetAnyNewOrders(out dt);
        }

        Console.WriteLine("Time taken: " + sw.ElapsedMilliseconds / (double)num);

        if (dt == null || dt.Rows.Count == 0)
        {

        }
    }

   public bool GetAnyNewOrders(out DataTable dt)
    {
        dt = null;

        try
        {

            string commandText = "SELECT * FROM [" + DBName + "].[LB].[Orders] WHERE [AccountIdent] = 'LB:B' AND [Exchange] = 'FX' AND [Status] = 'Sent'  ORDER BY [OrderDate],[OrderUTC] DESC";

            SqlCommand cmd = new SqlCommand
            {
                Connection = conn,
                CommandText = commandText
            };

            cmd.ExecuteNonQuery();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            dt = new DataTable();
            ds.Reset();
            da.Fill(ds);
            dt = ds.Tables[0];

            if (dt.Rows.Count == 0)
                return false;

            return true;
        }
        catch (Exception)
        {
            return false;
        }
    }